Re: Select <-> Case Insensitive

From: "Arguile" <arguile(at)lucentstudios(dot)com>
To: "Marcelo Pereira" <gandalf(at)sum(dot)desktop(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Select <-> Case Insensitive
Date: 2002-02-22 12:43:39
Message-ID: LLENKEMIODLDJNHBEFBOKELGEDAA.arguile@lucentstudios.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcelo Pereira writes
>
> How can I do a query make the `order' statment sort the tuples without
> looking for the `case' ?
>

I'm pretty sure a search of the archives would probably turn up the answer,
incase not though.

ORDER BY lower(field)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-02-22 12:44:48 Re: restoring 7.2 data to 7.3dev
Previous Message Marcelo Pereira 2002-02-22 12:32:21 Select <-> Case Insensitive