Re: Case insensitive ORDER BY - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Case insensitive ORDER BY
Date
Msg-id 20040319050249.GA16785@wolff.to
Whole thread Raw
In response to Re: Case insensitive ORDER BY  ("Alam Surya" <alam_it@csahome.com>)
List pgsql-general
On Fri, Mar 19, 2004 at 03:48:09 +0000,
  Alam Surya <alam_it@csahome.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.

pgsql-general by date:

Previous
From: "Alam Surya"
Date:
Subject: Re: Case insensitive ORDER BY
Next
From: Matthew Hixson
Date:
Subject: two phase commit