Re: [SQL] Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

2001-05-14 Thread David D. Kilzer
al_and ( SFUNC1 = booland, BASETYPE = bool, STYPE1 = bool, INITCOND1 = 't' ); Obviously, this concept could be extended for a logical 'OR' function and aggregate. Dave On Fri, May 11, 2001 at 12:33:52PM -0400, Tom Lane wrote: > "David D. Kilz

[SQL] Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

2001-05-11 Thread David D. Kilzer
, not finding a real-world solution. :^) Thanks! Dave On Mon, May 07, 2001 at 12:27:59PM -0500, David D. Kilzer wrote: > NOTE: I did a moderate search through the PgSQL mail list archives, > but couldn't find an example of a question where both ORDER BY and > aggregation were used

[SQL] Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement

2001-05-11 Thread David D. Kilzer
NOTE: I did a moderate search through the PgSQL mail list archives, but couldn't find an example of a question where both ORDER BY and aggregation were used. In all examples it was possible to use either one or the other with a possible subselect. [Keep reading...I discovered how to do this wit