Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.2/8.9.1) with ESMTP id MAA26537
	for <pgsql-sql@postgreSQL.org>; Fri, 29 Jan 1999 12:22:32 -0500 (EST)
	(envelope-from daveh@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA08715
	for pgsql-sql@postgreSQL.org; Fri, 29 Jan 1999 12:20:28 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!daveh using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA17584; Fri, 29 Jan 1999 12:02:40 -0500
Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA55648; Fri, 29 Jan 1999 12:02:40 -0500
Message-Id: <36B1E9D1.9CB0CE07@insightdist.com>
Date: Fri, 29 Jan 1999 12:03:13 -0500
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en
Mime-Version: 1.0
To: =?iso-8859-1?Q?=E1=CE=2F=D2?=:=
	=?iso-8859-1?Q?=EE=CF=D7=3Cnovikov=40webclub=2Eru=3E=CF=D7?=
	<novikov@webclub.ru>
Cc: pgsql-sql <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] ORDER BY
References: <9671.990129@webclub.ru>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

SELECT name FROM foo ORDER BY lower(name);

"áÎ/Ò:= îÏ×Ï×" wrote:

> Stupid question - can ORDER BY be case insensitive?
>
> Andrey