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
check the typo -- "ilike"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jaime Casanova
Sent: Tuesday, February 05, 2008 11:19 AM
To: Franklin Haut
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Cast in PG 8.3
On Feb 5, 2008 2:22 PM, Franklin Haut <[EM
