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?