Re: case-insensitive SELECT

tnx ! the use of a regular expression is a great solution ! it gives you the
power to do some very nice things !

tnx to all
bye

Giorgio A.
----- Original Message -----
From: "Ryan Ho" <ryanho@pacific.net.sg>
To: "Giorgio A." <jh@libero.it>; "PGSQL Novice List"
<pgsql-novice@postgresql.org>
Sent: Tuesday, June 12, 2001 4:52 AM
Subject: Re: [NOVICE] case-insensitive SELECT


> At 06:20 PM 6/11/01 +0200, 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 ?
>
> You're referring to text comparisons like "LIKE"?
> For case insensitive comparisons I normally use the regular expression
> method, which is "~*", where "*" means "to-ignore-case".
>
> e.g.
>
> SELECT address FROM people WHERE name ~* 'sam'
>
> Regards
> Ryan
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)