On 2008-02-28 09:13, Tom Lane wrote:
A rule of thumb is that ORDER BY in a view is bad design, IMHO.
regards, tom lane
I was surprised to find out that apparently it's also a PostgreSQL
extension; standard SQL apparently disallows ORDER BY in VIEWs:
http://en.wikipedia.org/wiki/Order_by_(SQL)
When I found this out, I removed all the ORDER BYs from my VIEWs (which
had been there for the convenience of subsequent SELECTs).
Of course, where ORDER BY in a VIEW is really helpful, is with OFFSET
and/or LIMIT clauses (which are also PostgreSQL extensions), which is
equivalent to what you point out.
--
Mail to my list address MUST be sent via the mailing list.
All other mail to my list address will bounce.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
