Is there any case when PostgreSQL adds an order by to a view *definition* in 7.4? I have evidence that create view .... results in create view .... ORDER BY ... as shown by \d viewname. The view does a five way ordinary join.
Any definitive answer would be very helpful. Thanks, Elein [EMAIL PROTECTED] -------------------------------------------------------------- [EMAIL PROTECTED] Varlena, LLC www.varlena.com (510)655-2584(o) (510)543-6079(c) PostgreSQL Consulting, Support & Training PostgreSQL General Bits http://www.varlena.com/GeneralBits/ -------------------------------------------------------------- I have always depended on the [QA] of strangers. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org