Re: Queries

From: Oliver Vecernik <vecernik(at)aon(dot)at>
To: tsattler(at)speakeasy(dot)net
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Queries
Date: 2001-05-04 21:49:22
Message-ID: 3AF323E2.CBD5ED27@aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

tsattler(at)speakeasy(dot)net wrote:
>
> Greetings All.
>
> I have a record on my database with a last name of 'DeFelice'.
>
> I want to be able to retrieve that record whether a user enters 'DeFelice', 'Defelice', 'defelice', or 'DEFELICE'. Is there a way I can do that? Is that what the "ilike" function does?
>
> I'm on 7.0.3.

~* Match (regex), case insensitive is what you are looking for.

Regards,
Oliver

In response to

  • Queries at 2001-05-04 15:12:00 from tsattler

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2001-05-04 22:08:34 Re: Re: Use of the LIMIT clause ?
Previous Message Peter Eisentraut 2001-05-04 21:46:46 Re: createuser withpassword