Postgres Pro
Downloads
Home   >   mailing lists

Re: Select <-> Case Insensitive - Mailing list pgsql-general

From Arguile
Subject Re: Select <-> Case Insensitive
Date
Msg-id LLENKEMIODLDJNHBEFBOKELGEDAA.arguile@lucentstudios.com
Whole thread Raw
In response to Select <-> Case Insensitive  (Marcelo Pereira <gandalf@sum.desktop.com.br>)
Responses Re: Select <-> Case Insensitive
List pgsql-general
Tree view 
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)

pgsql-general by date:

Previous
From: Marcelo Pereira
Date:
Subject: Select <-> Case Insensitive
Next
From: Bruce Momjian
Date:
Subject: Re: restoring 7.2 data to 7.3dev