Quick Links

case-insensitive SELECT

From:	"Giorgio A(dot)" <jh(at)libero(dot)it>
To:	"PGSQL Novice List" <pgsql-novice(at)postgresql(dot)org>
Subject:	case-insensitive SELECT
Date:	2001-06-11 16:20:11
Message-ID:	00cc01c0f292$65111820$3302a8c0@ducale.mentelocale.bogus
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
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.

In response to

Multiple Columns Keys - Good or Bad idea? at 2001-06-11 08:09:54 from Rob Brown-Bayliss

Responses

Re: case-insensitive SELECT at 2001-06-12 00:04:14 from Johan Daine
Re: case-insensitive SELECT at 2001-06-12 02:52:38 from Ryan Ho

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Tom Lane	2001-06-11 18:59:59	Re: FATAL ERROR
Previous Message	Michael Roth	2001-06-11 16:14:43	FATAL ERROR