X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4192F54CD6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 23 Feb 2005 20:18:09 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 22596-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 23 Feb 2005 20:17:59 +0000 (GMT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id 1922D54C58
	for <pgsql-sql@postgresql.org>; Wed, 23 Feb 2005 20:17:58 +0000 (GMT)
Received: (qmail 22001 invoked by uid 500); 23 Feb 2005 20:33:22 -0000
Date: Wed, 23 Feb 2005 14:33:22 -0600
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
Message-ID: <20050223203322.GA21904@wolff.to>
Mail-Followup-To: "Thomas F.O'Connell" <tfo@sitening.com>,
	PgSQL - SQL <pgsql-sql@postgresql.org>
References: <200502160055.59288.andreak@officenet.no>
	<20050216044735.GA2343@wolff.to>
	<200502160939.27431.andreak@officenet.no>
	<b27f2f6549c676ab0afe3b615e905230@sitening.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <b27f2f6549c676ab0afe3b615e905230@sitening.com>
User-Agent: Mutt/1.5.6i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.112 tagged_above=0 required=5 tests=AWL,
	UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200502/281
X-Sequence-Number: 20391

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.