Received: from web10004.mail.yahoo.com (web10004.mail.yahoo.com [216.136.130.40]) by postgresql.org (8.11.3/8.11.4) with SMTP id f94Jlmn56985 for ; Thu, 4 Oct 2001 15:47:48 -0400 (EDT) (envelope-from jdearl@yahoo.com) Message-ID: <20011004194746.21583.qmail@web10004.mail.yahoo.com> Received: from [12.18.144.101] by web10004.mail.yahoo.com via HTTP; Thu, 04 Oct 2001 12:47:46 PDT Date: Thu, 4 Oct 2001 12:47:46 -0700 (PDT) From: Jason Earl Subject: Re: ORDER BY case insensitive? To: Bob Swerdlow , pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200110/63 X-Sequence-Number: 5018 SELECT * FROM MyTable ORDER BY lower(Name); Should do the trick. Jason Earl --- Bob Swerdlow wrote: > How do I get the rows sorted in a case insensitive > way? > > I have some queries that basically fit the form: > SELECT * FROM MyTable ORDER BY Name; > When I view the results, all of the Name's that > start with an upper case > letter precede all of the Name's that start with a > lower case letter. I > want them all in alphabetic order, regardless of > case. > > I've looked in PostgreSQL Introduction and Concepts > by Bruce Momjian and in > the FAQ at > http://postgresql.overtone.org/docs/faq-english.html > > Thanks for your help. > > -- > Bob Swerdlow > Chief Operating Officer > Transpose, LLC > rswerdlow@transpose.com > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org __________________________________________________ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1