Adding order bys to the view definitions (7.4)

From: elein <elein(at)varlena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: Adding order bys to the view definitions (7.4)
Date: 2005-12-02 17:55:05
Message-ID: 20051202175505.GN26986@varlena.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)varlena(dot)com
--------------------------------------------------------------
elein(at)varlena(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul Møller Hansen 2005-12-02 17:55:34 Re: Slow COUNT
Previous Message Francesco Formenti - TVBLOB S.r.l. 2005-12-02 17:49:49 [Fwd: Re: deadlock on the same relation]