Quoting Tom Lane <[EMAIL PROTECTED]>:
> Klint Gore <[EMAIL PROTECTED]> 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."
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
