"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
_/ /_/ _/
_/ /_/ _/
/_/_/_/ /_/_/_/