Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?
Дата
Msg-id CAKFQuwbmGjSvP=Kv1Yz_gNUOemHag_JQoS8tuaYrztqwuG_DEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Sv: Re: Is ORDER BY in sub-query preserved when outer query is only projection?  (Andreas Joseph Krogh <andreas@visena.com>)
Ответы Sv: Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
Дерево обсуждения
On Sun, Jan 14, 2018 at 5:40 AM, Andreas Joseph Krogh <andreas@visena.com> wrote:
På søndag 14. januar 2018 kl. 13:30:29, skrev Francisco Olarte <folarte@peoplecall.com>:
Andreas:

On Sun, Jan 14, 2018 at 1:03 PM, Andreas Joseph Krogh
<andreas@visena.com> wrote:
> SELECT q.* FROM (
>   SELECT comp.id, comp.name
>   FROM company comp JOIN req r ON r.company_id = comp.id
>   ORDER BY LOWER(comp.name) ASC
> ) AS q
> ORDER BY r.status ASC

 
Do you see any solution sorting on a composite type without using an outer query?


​Tacking on ORDER BY to an inner query is generally not the right thing to do.

​What can you not write:

SELECT q.* FROM () AS q
ORDER BY lower(q.name)​ ASC, q.status ASC
?

Also, ORDER BY r.status ASC in you original query shouldn't work - r is not visible at that point, only q is.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Haroldo Stenger
Дата:
Сообщение: Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Sv: Re: Re: Is ORDER BY in sub-query preserved when outer query is only projection?