Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)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."