the column is an integer, no sense for case sensitive or insensitive... change it to 'like', you'll get what you want.
-----Original Message----- From: Jaime Casanova [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 05, 2008 11:47 AM To: Li, Jingfa Cc: Franklin Haut; pgsql-sql@postgresql.org Subject: Re: [SQL] Cast in PG 8.3 On Feb 5, 2008 2:39 PM, Li, Jingfa <[EMAIL PROTECTED]> wrote: > check the typo -- "ilike" > that's not a typo, it's "case insensitive LIKE" -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend