Re: taking a stab at agg(foo ORDER BY bar) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: taking a stab at agg(foo ORDER BY bar)
Date
Msg-id 8950.1254669010@sss.pgh.pa.us
Whole thread Raw
In response to taking a stab at agg(foo ORDER BY bar)  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> This doesn't seem to present any problems as far as the syntax goes,
> and the actual execution is just a small matter of coding, but I'm not
> seeing the best way to handle it in parse-analysis. All the existing
> infrastructure for ORDER BY seems to be dependent on targetlists, which
> obviously we don't have in the context of an aggregate call.

Well, if you don't want to refactor that code, it wouldn't be difficult
to make a one-entry tlist containing the aggregate argument, and then
throw it away again after you'd extracted what you need.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting the red out (of the buildfarm)
Next
From: Tom Lane
Date:
Subject: Re: Using results from INSERT ... RETURNING