pattern matching - Mailing list pgsql-novice

From Alan Nilsson
Subject pattern matching
Date
Msg-id 01fe01c07ab4$65fdaec0$5e22ca11@apple.com
Whole thread Raw
Responses Re: pattern matching  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-novice
I am trying to search for text(varchar) using the ILIKE operator, however I always get a parser error.  Similarly the ~~* operator does not work. (actually, doesn't exist)
 
Can anyone tell me whether this feature is implemented yet or not.
 
If not, is there an easy way to perform case-insensitive 'LIKE' search's?
Alan Nilsson
anilsson@apple.com
How hard can it be?

pgsql-novice by date:

Previous
From: Sandeep Joshi
Date:
Subject: delete trigger function in 'C'
Next
From: "Brett W. McCoy"
Date:
Subject: Re: pattern matching