Horton

Re: case-insensitive SELECT

Johan Daine <isis@wanadoo.be>

View thread View on postgr.es
From: Johan Daine <isis@wanadoo.be>
To: "Giorgio A." <jh@libero.it>
Cc: PGSQL Novice List <pgsql-novice@postgresql.org>
Date: 2001-06-12T00:04:14Z
Lists: pgsql-novice 
"Giorgio A." wrote:

> hi, i'm trieing to do a case-insensitive SELECT but i can't find a tag
> preposed to this scope.
>
> i tried to use ILIKE but i get a pg_error.... maybe it's not implemented in
> version 7.0.3 ? if so, have i any alternative way to do this
> case-insensitive SELECT ?
>
> tnx to all
>
> Giorgio A.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

Postgres has a regexp case insensitive comparision operator:  '~*'
See :
http://www.fr.postgresql.org/users-lounge/docs/7.1/user/functions-matching.html#FUNCTIONS-REGEXP

Good luck...
--
           _/    /_/_/_/            Johan Daine
          _/    /_/    _/           mailto:isis@wanadoo.be
         _/    /_/    _/            http://thot.dyndns.org:6080
        _/    /_/    _/
       _/    /_/    _/
 /_/_/_/    /_/_/_/