Horton

case-insensitive SELECT

Giorgio A. <jh@libero.it>

View thread View on postgr.es
From: "Giorgio A." <jh@libero.it>
To: "PGSQL Novice List" <pgsql-novice@postgresql.org>
Date: 2001-06-11T16:20:11Z
Lists: pgsql-novice 
hi, i'm trieing to do a case-insensitive SELECT but i can't find a tag
preposed to this scope.

i tried to use ILIKE but i get a pg_error.... maybe it's not implemented in
version 7.0.3 ? if so, have i any alternative way to do this
case-insensitive SELECT ?

tnx to all

Giorgio A.