On Sat, 2008-03-29 at 07:07 +0530, Gurjeet Singh wrote: > On Sat, Mar 29, 2008 at 3:21 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> regression=# select max(unique1), generate_series(1,3) as g > from tenk1 order by g desc; > max | g > ------+--- > 9999 | 1 > 9999 | 2 > 9999 | 3 > (3 rows) > > > In the past I had seen suggestions (perhaps from you) that we should > disallow SRFs in target list... Although not for 8.3, but would this > be a good time for 8.4 to deprecate the usage of SRFs in targetlist? I think it makes sense to throw an error if we have both ungrouped aggregates and SRFs in the targetlist. The two concepts seem at odds with each other anyhow. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
