Ooops, posted this to Phillip rather than the list, sorry Phillip ...
Folks,
Philip Warner wrote:
>
> At 15:23 20/09/00 +0200, Louis-David Mitterrand wrote:
> >
> >ERROR: parser: parse error at or near "order"
> >
> >Aren't ORDER BY clauses allowed in subselects?
> >
>
> It is a very very sad fact, but, no, they're not.
Hmmmm ... can't say as I've ever seen an ORDER BY in a subselect before.
Why would you want one?
And if you do want one, Louis-David, you can always use a temporary
table as previously described.
-Josh
--
______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete
informationtechnology josh@agliodbs.com and data management solutions (415) 436-9166 for law firms, small
businesses fax 436-0137 and non-profit organizations. pager 338-4078 San
Francisco