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 elein@xxxxxxxxxxx -------------------------------------------------------------- elein@xxxxxxxxxxx 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.