Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-06-11 18:59:59
Subject: Re: FATAL ERROR
Previous:From: Michael RothDate: 2001-06-11 16:14:43
Subject: FATAL ERROR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group