Adding order bys to the view definitions (7.4) - Mailing list pgsql-general

From elein
Subject Adding order bys to the view definitions (7.4)
Date
Msg-id 20051202175505.GN26986@varlena.com
Whole thread Raw
Responses Re: Adding order bys to the view definitions (7.4)
List pgsql-general
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@varlena.com
--------------------------------------------------------------
elein@varlena.com        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.


pgsql-general by date:

Previous
From: Poul Møller Hansen
Date:
Subject: Re: Slow COUNT
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: Slow COUNT