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
informationtechnology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small
businesses fax 621-2533 and non-profit organizations. San Francisco