case-insensitive SELECT - Mailing list pgsql-novice

From Giorgio A.
Subject case-insensitive SELECT
Date
Msg-id 00cc01c0f292$65111820$3302a8c0@ducale.mentelocale.bogus
Whole thread Raw
In response to Multiple Columns Keys - Good or Bad idea?  (Rob Brown-Bayliss <rob@ZOOstation.cc>)
Responses Re: case-insensitive SELECT
List 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.


pgsql-novice by date:

Previous
From: "Michael Roth"
Date:
Subject: FATAL ERROR
Next
From: Tom Lane
Date:
Subject: Re: FATAL ERROR