Re: case-insensitive SELECT

"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(at)postgresql(dot)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(at)wanadoo(dot)be
_/ /_/ _/ http://thot.dyndns.org:6080
_/ /_/ _/
_/ /_/ _/
/_/_/_/ /_/_/_/