Re: Case insensitive ORDER BY

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Mark Lubratt <mark(dot)lubratt(at)indeq(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Case insensitive ORDER BY
Date: 2004-03-18 16:31:31
Message-ID: 232660000.1079627491@lerlaptop-red.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--On Thursday, March 18, 2004 10:04:35 -0600 Mark Lubratt
<mark(dot)lubratt(at)indeq(dot)com> wrote:

> Is there a way to make ORDER BY case insensitive?
order by lower(string);

>
> Thanks!
> Mark
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-03-18 16:48:20 Re: Case insensitive ORDER BY
Previous Message Tom Lane 2004-03-18 16:28:32 Re: Opteron build process question