Re: [SQL] Howto to force NULL rows at the bottom ?
От
Stoyan Genov
Тема
Re: [SQL] Howto to force NULL rows at the bottom ?
Дата
Msg-id
199912051153.NAA24720@lorna.digsys.bg
Ответ на
Howto to force NULL rows at the bottom ? (Dirk Lutzebaeck)
Список
Дерево обсуждения
Howto to force NULL rows at the bottom ? Dirk Lutzebaeck <lutzeb@aeccom.com>
Re: [SQL] Howto to force NULL rows at the bottom ? Bruce Momjian <pgman@candle.pha.pa.us>
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 ? Peter Eisentraut <peter_e@gmx.net>
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 ? Tom Lane <tgl@sss.pgh.pa.us>
RE: [SQL] Howto to force NULL rows at the bottom ? "Hiroshi Inoue" <Inoue@tpf.co.jp>
Re: [SQL] Howto to force NULL rows at the bottom ? Tom Lane <tgl@sss.pgh.pa.us>
Re: [SQL] Howto to force NULL rows at the bottom ? Bruce Momjian <pgman@candle.pha.pa.us>
Re: [SQL] Howto to force NULL rows at the bottom ? Tom Lane <tgl@sss.pgh.pa.us>
Re: [SQL] Howto to force NULL rows at the bottom ? Dirk Lutzebaeck <lutzeb@aeccom.com>
Re: [SQL] Howto to force NULL rows at the bottom ? Bruce Momjian <pgman@candle.pha.pa.us>
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 > > ************ >
В списке pgsql-sql по дате отправления
