Re: Case insensitive ORDER BY

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alam Surya <alam_it(at)csahome(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, id-postgresql(at)yahoogroups(dot)com
Subject: Re: Case insensitive ORDER BY
Date: 2004-03-19 05:02:49
Message-ID: 20040319050249.GA16785@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Mar 19, 2004 at 03:48:09 +0000,
Alam Surya <alam_it(at)csahome(dot)com> wrote:
> dear expert...
>
> why does CLAUSE ORDER BY in POSTAGE SQL must have CASE SENSITIVE, what is
> the basic thought? isn't it ORDER BY function is only just a filter
> shorting?

You can use functions in an ORDER BY clause. If you want case insensitive
ordering, order by lower (or upper) of your key.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Hixson 2004-03-19 05:08:07 two phase commit
Previous Message Alam Surya 2004-03-19 04:11:24 Re: Case insensitive ORDER BY