Re: Select <-> Case Insensitive

From: Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br>
To: Arguile <arguile(at)lucentstudios(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Select <-> Case Insensitive
Date: 2002-02-22 13:34:35
Message-ID: Pine.LNX.4.20.0202221034200.18090-100000@ni.hmmg.sp.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok,

Thanks

Marcelo Pereira

-- Remember that only God and Esc+:w saves.
__
(_.\ Marcelo Pereira |
/ / ___ |
/ (_/ _ \__ Matematica/99 - IMECC |
_______\____/_\___)___Unicamp_______________/

--- Arguile, with his fast fingers, wrote:

:> 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

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo Pereira 2002-02-22 13:34:51 Re: Select <-> Case Insensitive
Previous Message Pam Wampler 2002-02-22 13:30:54 Re: number of connections to postmaster