X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4F6CD1DCD6 for ; Sun, 15 Feb 2004 19:02:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62708-05 for ; Sun, 15 Feb 2004 15:02:25 -0400 (AST) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 754F8D1DCF1 for ; Sun, 15 Feb 2004 15:02:24 -0400 (AST) Received: from [134.22.69.233] (dyn-69-233.tor.dsl.tht.net [134.22.69.233]) by tht.net (Postfix) with ESMTP id 3517A76A1E; Sun, 15 Feb 2004 14:02:27 -0500 (EST) Subject: Re: ORDER BY TIMESTAMP_column ASC, NULL first From: Rod Taylor To: Fredrik Wendt Cc: pgsql-sql@postgresql.org In-Reply-To: <20040212100626.GA21864@csbnet.se> References: <20040212100626.GA21864@csbnet.se> Content-Type: text/plain Message-Id: <1076871769.10896.140.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 15 Feb 2004 14:02:49 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/187 X-Sequence-Number: 16877 On Thu, 2004-02-12 at 05:06, Fredrik Wendt wrote: > Hi! > > I read posts telling me that NULL values are considered greater than > non-null values. Fine. Is there a way to explicitly reverse this? ORDER BY column IS NOT NULL, column ASC;