Skip site navigation (1) Skip section navigation (2)

Re: bitwise and/or aggregate functions?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bitwise and/or aggregate functions?
Date: 2004-04-28 08:08:07
Message-ID: Pine.LNX.4.58.0404280957280.28436@sablons.cri.ensmp.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
> > SELECT BIT_OR(aclitem_privs(...)) AS effective_privs
> > FROM ...
> > WHERE aclitem_grantee(...)=... AND ... ;
>
> Is there anything in SQL2003 about such operators?  If there is, we
> should make sure we use the correct aggregate names.

That's a point!

I thought of BIT_* because it is short and also used by mysql.
Ingres has BIT_AND and BIT_OR functions, but they are not aggregates.

I don't know where these standards are available online... It seems they
are not available:-(

-- 
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr

In response to

Responses

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2004-04-28 08:10:53
Subject: Re: TPC H data
Previous:From: Simon RiggsDate: 2004-04-28 08:05:13
Subject: PITR Phase 1 Code Review

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group