Tom,

> Yes, that oughta work fine to determine the order of inputs to the
> aggregate function.  ORDER BY in sub-selects is a new feature (heck,
> sub-selects in FROM at all is a new feature) in 7.1, so this trick
> wasn't available when Richard and I discussed the issue before.

Hey, why do you think that I was bugging you about 7.1 for months?  You
should see some of the things I do with sub-selects.   Err ...
programming-wise, that is ;-)

Speaking of which, when's the 7.1 release?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      [EMAIL PROTECTED]
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to