| 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: | Raw Message | Whole Thread | 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.
| 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] |