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