From: Bruno Wolff III <bruno@wolff.to>
To: Thomas F.O'Connell <tfo@sitening.com>
Cc: PgSQL - SQL <pgsql-sql@postgresql.org>
Subject: Re: Making NULL entries appear first when ORDER BY <field> ASC
Date: Wed, 23 Feb 2005 14:33:22 -0600
Message-ID: <20050223203322.GA21904@wolff.to> (raw)
In-Reply-To: <b27f2f6549c676ab0afe3b615e905230@sitening.com>
References: <200502160055.59288.andreak@officenet.no>
<20050216044735.GA2343@wolff.to>
<200502160939.27431.andreak@officenet.no>
<b27f2f6549c676ab0afe3b615e905230@sitening.com>
On Wed, Feb 23, 2005 at 13:54:50 -0600,
"Thomas F.O'Connell" <tfo@sitening.com> wrote:
> How would one know from the reference material that it is possible to
> include IS NOT NULL in an ORDER BY clause?
>
> Similarly, other than the FAQ, I've never been able to tell from the
> SELECT documentation why ORDER BY random() works.
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: bruno@wolff.to, tfo@sitening.com
Subject: Re: Making NULL entries appear first when ORDER BY <field> ASC
In-Reply-To: <20050223203322.GA21904@wolff.to>
* 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