From: Fredrik Wendt <fredrik@csbnet.se>
To: pgsql-sql@postgresql.org
Subject: ORDER BY TIMESTAMP_column ASC, NULL first
Date: Thu, 12 Feb 2004 11:06:26 +0100
Message-ID: <20040212100626.GA21864@csbnet.se> (raw)
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?
I have the situation where a table holds IP-addresses. The table has
column of type timestamp, called assignedAt, which tells when the
address was assigned to a computer in our network.
What I'd like to do, is to get an IP-address that hasn't yet been
assigned to anyone, or the one with the smallest assignedAt (most likely
to not be in use).
CREATE TABLE IPv4Address (
id SERIAL PRIMARY KEY,
address INET NOT NULL UNIQUE,
assignedAt TIMESTAMP
);
The query to use would be,
SELECT ip.id FROM IPv4Address ip ORDER BY assignedAt ASC LIMIT 1;
with the exception that this returns rows with NULL at the end, instead
of at the beginning which is what I'd like.
How do achieve this with one query? I'm using Postgres 7.4.
And oh, I'm not on the list so please cc my adress in any replies!
Thanks in advance,
Fredrik Wendt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fredrik@csbnet.se
Subject: Re: ORDER BY TIMESTAMP_column ASC, NULL first
In-Reply-To: <20040212100626.GA21864@csbnet.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox