Re: ORDER BY
От | Chris Mulcahy |
---|---|
Тема | Re: ORDER BY |
Дата | |
Msg-id | 1163634782.29042.2.camel@gentoobox обсуждение исходный текст |
Ответ на | Re: ORDER BY ("George Pavlov" <gpavlov@mynewplace.com>) |
Ответы |
Re: ORDER BY
|
Список | pgsql-general |
On Wed, 2006-11-15 at 14:59 -0800, George Pavlov wrote: Alas, this suggestion is wrong on two counts: (a) UNION expects a single > ORDER BY that applies to the whole recordset and which has to come at > the end; (b) UNION re-sorts anyway (it needs to eliminate the dupes) -- > maybe you are thinking UNION ALL? So, to follow your advice he may want > a query like this, although it seems quite silly and there still isn't > an ironclad guarantee re. the final result sorting: > > select * from > (select * from foo where name != 'Other' order by name) x > union all > select * from foo where name = 'Other' > > Here ya go. select 1 SortCol, * from foo where name != 'Other' UNION ALL select 2 SortCol, * from foo where name = 'Other' order by SortCol;
В списке pgsql-general по дате отправления: