Received: from merganser.its.uu.se (merganser.its.uu.se [130.238.6.236]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA86701 for ; Sun, 5 Dec 1999 17:51:56 -0500 (EST) (envelope-from peter@localhost.its.uu.se) Received: from regulus.its.uu.se ([130.238.7.19]:64663 "EHLO regulus.its.uu.se") by merganser.its.uu.se with ESMTP id ; Sun, 5 Dec 1999 23:51:38 +0100 Received: from peter (helo=localhost) by regulus.its.uu.se with local-esmtp (Exim 3.02 #2) id 11ukZw-0002sA-00; Sun, 05 Dec 1999 23:56:28 +0100 Date: Sun, 5 Dec 1999 23:56:28 +0100 (CET) From: Peter Eisentraut To: Stoyan Genov cc: Dirk Lutzebaeck , pgsql-sql@postgresql.org Subject: Re: [SQL] Howto to force NULL rows at the bottom ? In-Reply-To: <199912051153.NAA24720@lorna.digsys.bg> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT Sender: Peter Eisentraut 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