Re: new aggregate functions v1

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: new aggregate functions v1
Дата
Msg-id Pine.GSO.4.58.0405021049340.27282@chailly99
обсуждение исходный текст
Ответ на Re: new aggregate functions v1  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Ответы Re: new aggregate functions v1  (Peter Eisentraut <peter_e@gmx.net>)
Re: new aggregate functions v1  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-patches
Dear Alvaro,

> > (2) bitwise integer aggregates named bit_and and bit_or for
> >     int2, int4, int8 and bit types. They are not standard,
> >     however they exist in other db (eg mysql), and I needed them
> >     for some other stuff.
>
> I'm sure people won't like to add functions just because "some other DB
> has them".

I develop them because I NEEDED them, NOT because they are available
in mysql and I would want compatibility. I needed them for some queries
over pg_catalog, as acl are encoded as bitfields.

So the addition is about functionnality, not compatibility.

The argument about mysql is rather to show that other people in the world
found these functions also useful, and to justify the name I chose.

You may also notice that the impact in close to void, there are two lines
added for each of these bit_* functions. I'm not going to develop an
external package for 16 lines of code.

--
Fabien Coelho - coelho@cri.ensmp.fr

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: mingw regression test fixes
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: new aggregate functions v1