On Sun, Jan 14, 2018 at 5:40 AM, Andreas Joseph Krogh <andr...@visena.com> wrote:
> På søndag 14. januar 2018 kl. 13:30:29, skrev Francisco Olarte < > fola...@peoplecall.com>: > > Andreas: > > On Sun, Jan 14, 2018 at 1:03 PM, Andreas Joseph Krogh > <andr...@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.
