On Tue, 9 Jan 2001, Alan Nilsson wrote:
> 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)
The case-insensitive regexp operator is ~*, and it does work in
PostgreSQL. There is no ~~* or ILIKE, but you can do LIKE UPPER('*text*')
to achieve the same thing.
-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
According to my best recollection, I don't remember.
-- Vincent "Jimmy Blue Eyes" Alo