Adding order bys to the view definitions (7.4)

Поиск
Список
Период
Сортировка
От elein
Тема Adding order bys to the view definitions (7.4)
Дата
Msg-id 20051202175505.GN26986@varlena.com
обсуждение исходный текст
Ответы Re: Adding order bys to the view definitions (7.4)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Poul Møller Hansen
Дата:
Сообщение: Re: Slow COUNT
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: Slow COUNT