Re: two-argument aggregates and SQL 2003 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: two-argument aggregates and SQL 2003
Date
Msg-id 20390.1144942454@sss.pgh.pa.us
Whole thread Raw
In response to two-argument aggregates and SQL 2003  ("Sergey E. Koposov" <math@sai.msu.ru>)
Responses Re: two-argument aggregates and SQL 2003  ("Sergey E. Koposov" <math@sai.msu.ru>)
Re: two-argument aggregates and SQL 2003  (Mark Dilger <pgsql@markdilger.com>)
List pgsql-hackers
"Sergey E. Koposov" <math@sai.msu.ru> writes:
> ... Nothing else and nothing internal need not to be changed to
> insert new two-arg. aggregate functions into the core.  
> Am I right in this ? 

IIRC the main issues are the syntax of CREATE AGGREGATE and the actual
implementation in nodeAgg.c.  See previous discussions, eg
http://archives.postgresql.org/pgsql-general/2006-03/msg00512.php

I would really prefer to see CREATE AGGREGATE normalized to have a
syntax comparable to CREATE FUNCTION (or DROP AGGREGATE for that
matter):CREATE AGGREGATE aggname (typname [, ... ])  ...definition...
but it's not clear how to get there without breaking backwards
compatibility :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Practical impediment to supporting multiple SSL libraries
Next
From: Tom Lane
Date:
Subject: Re: Practical impediment to supporting multiple SSL libraries