Quoting Tom Lane <tgl@sss.pgh.pa.us>:
> Klint Gore <kg@kgb.une.edu.au> writes:
> > Is having an order by in a view legal?
>
> Not according to the SQL spec, but PG has allowed it for several releases.
> (The same goes for ORDER BY in a sub-select, which is actually pretty
> much the same thing ...)
Umm... if you implement LIMIT in a subselect, it becomes highly meaningful (nad
useful.
Is this a case of one nonstandard feature being the thin edge of the wedge
for another?
--
"Dreams come true, not free."
