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

Re: case-insensitive SELECT

From: "Giorgio A(dot)" <jh(at)libero(dot)it>
To: "PGSQL Novice List" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: case-insensitive SELECT
Date: 2001-06-12 07:53:38
Message-ID: 002901c0f314$cc846ca0$0201a8c0@casa (view raw or flat)
Thread:
Lists: pgsql-novice
tnx ! the use of a regular expression is a great solution ! it gives you the
power to do some very nice things !

tnx to all
bye

Giorgio A.
----- Original Message -----
From: "Ryan Ho" <ryanho(at)pacific(dot)net(dot)sg>
To: "Giorgio A." <jh(at)libero(dot)it>; "PGSQL Novice List"
<pgsql-novice(at)postgresql(dot)org>
Sent: Tuesday, June 12, 2001 4:52 AM
Subject: Re: [NOVICE] case-insensitive SELECT


> At 06:20 PM 6/11/01 +0200, Giorgio A. wrote:
> >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 ?
>
> You're referring to text comparisons like "LIKE"?
> For case insensitive comparisons I normally use the regular expression
> method, which is "~*", where "*" means "to-ignore-case".
>
> e.g.
>
> SELECT address FROM people WHERE name ~* 'sam'
>
> Regards
> Ryan
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)


In response to

pgsql-novice by date

Next:From: Nikola MilutinovicDate: 2001-06-12 09:01:49
Subject: PostgreSQL problem with functions
Previous:From: Ryan HoDate: 2001-06-12 02:52:38
Subject: Re: case-insensitive SELECT

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