order/aggregate thing is a general question.
>
> Yes.
>
> You can even do this with GROUP BY as long as the leading columns of the ORDER
> BY inside the subquery exactly matches the GROUP BY columns.
>
> In theory we can't promise anything about future versions of Postgres but
> there are lots of people doing this already so if ever this was lost there
> would probably be some new explicit way to achieve the same thing.
Does anyone have any spec links, oracle behavior, or whatever? For
now I will trust Postgres to continue behaving sanely, but I am
curious.
Thx to Gregory for the quick reply
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
>