Re: pattern matching

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