Skip site navigation (1) Skip section navigation (2)

Re: Strange aggregate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Strange aggregate
Date: 2003-03-24 17:23:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
> Is there possibility to write aggregate returns setof value?

Not with the present implementation.

I suppose we could think about postponing the call to the finalfunction
so that it's executed by execQual.c while evaluating an Agg node's
output tlist, and then something like that could work.  But I'm not sure
we really want to go that way.  Set-returning functions in targetlists
are a mess that we should try to get rid of, not enhance.

Can you think of a plausible syntax for an aggregate as a table function
(ie, in a FROM item, instead of a target list)?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Neil ConwayDate: 2003-03-24 17:24:27
Subject: Re: cursors: SCROLL default, error messages
Previous:From: Neil ConwayDate: 2003-03-24 17:17:29
Subject: DEFAULT in <set clause list>

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group