Re: [SQL] Howto to force NULL rows at the bottom ?
От | Peter Eisentraut |
---|---|
Тема | Re: [SQL] Howto to force NULL rows at the bottom ? |
Дата | |
Msg-id | Pine.LNX.4.20.9912051642510.349-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: [SQL] Howto to force NULL rows at the bottom ? (Stoyan Genov <genov@digsys.bg>) |
Ответы |
Re: [SQL] Howto to force NULL rows at the bottom ?
Re: [SQL] Howto to force NULL rows at the bottom ? |
Список | pgsql-sql |
Always test everything you say. The NULLs will come out at the end no matter which way you order it. There is a TODO item for this, but I suspect that the function manager clean up needs to be completed first, because there are a lot of subtle and not so subtle problems with NULLs all over the place. -Peter On 1999-12-05, Stoyan Genov mentioned: > Hi, > > If you bother about the NULLs positioned at the bottom of the selection, > and not how > non-NULL data is ordered, you can just use ORDER BY field DESC - this will > position > NULLs at the bottom, ordering non-NULL data from the highest values to the > lowest. > > Regards, > Stoyan Genov > > > Hi, > > > > how can I force NULL rows at the bottom of the result list in an > > ordered SELECT? > > > > with ORDER BY I get > > > > NULL > > Peter > > Jane > > > > but I want > > > > Peter > > Jane > > NULL > > > > -- > > Dirk > > > > ************ > > > > > > ************ > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
В списке pgsql-sql по дате отправления: