Re: bitwise and/or aggregate functions?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: bitwise and/or aggregate functions?
Дата
Msg-id Pine.LNX.4.58.0404280957280.28436@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответ на Re: bitwise and/or aggregate functions?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: bitwise and/or aggregate functions?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список 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@cri.ensmp.fr


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: PITR Phase 1 Code Review
Следующее
От: Mark Kirkwood
Дата:
Сообщение: Re: [GENERAL] TPC H data