Re: creating aggregates that work on composite types (whole tuples) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: creating aggregates that work on composite types (whole tuples)
Date
Msg-id 2145.1028040594@sss.pgh.pa.us
Whole thread Raw
In response to creating aggregates that work on composite types (whole tuples)  (Hannu Krosing <hannu@tm.ee>)
Responses Re: creating aggregates that work on composite types  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> I am trying to create an aggregate function that works on whole tuples,
> but the system does not find them once defined ;(
> hannu=# select tabulate(users) from users;
> ERROR:  No such attribute or function 'tabulate'

This seems to work in CVS tip.  I think you're stuck in older releases
though.  The syntax "foo(tablename)" is understood to mean "either a
column selection or a function call" ... but aggregates were quite
distinct from plain functions up until about a month ago, and they
weren't considered as an option at that spot in the code.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Virus Emails
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Password sub-process ...