Re: new aggregate functions v1 - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: new aggregate functions v1
Date
Msg-id 40A96736.7030808@familyhealth.com.au
Whole thread Raw
In response to Re: new aggregate functions v1  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: new aggregate functions v1
List pgsql-patches
What does this patch have to do with ACLs?  Wasn't that Fabien's
previous patch?

Chris

Bruce Momjian wrote:

> Where are on this?  Without a user-visible way of seeing the acl values,
> is this still useful?
>
> ---------------------------------------------------------------------------
>
> Fabien COELHO wrote:
>
>>Dear patchers,
>>
>>please find attached a small patch for adding new aggregate functions:
>>
>>(1) boolean-and and boolean-or aggregates named bool_and and bool_or.
>>    they correspond to standard sql every and some/any aggregates.
>>    they do not have the right name as there is a problem with
>>    the standard and the parser for some/any.
>>
>>(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.
>>
>>
>>The patch adds:
>>
>>- 3 new functions for boolean aggregates in src/backed/utils/adt/bool.c,
>>  src/include/utils/builtins.h and src/include/catalog/pg_proc.h
>>
>>- new aggregates declared in src/include/catalog/pg_proc.h and
>>  src/include/catalog/pg_aggregate.h
>>
>>- some documentation and validation about these new aggregates.
>>
>>It also updates the catalog version. It validates for me.
>>
>>Have a nice day,
>>
>>--
>>Fabien Coelho - coelho@cri.ensmp.fr
>
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>

pgsql-patches by date:

Previous
From: Sean Chittenden
Date:
Subject: New function: area(PATH)...
Next
From: Bruce Momjian
Date:
Subject: Re: new aggregate functions v1