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?
|
| Список | pgsql-general |
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 ASCDo 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 по дате отправления: