Re: new aggregate functions v1

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: new aggregate functions v1
Date: 2004-05-18 01:30:30
Message-ID: 40A96736.7030808@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cri(dot)ensmp(dot)fr
>
>
> Content-Description:
>
> [ Attachment, skipping... ]
>
>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>> http://www.postgresql.org/docs/faqs/FAQ.html
>
>

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-05-18 03:26:30 Re: new aggregate functions v1
Previous Message Sean Chittenden 2004-05-17 21:39:31 New function: area(PATH)...