Queries

From: tsattler(at)speakeasy(dot)net
To: pgsql-admin(at)postgresql(dot)org
Subject: Queries
Date: 2001-05-04 15:12:00
Message-ID: 200105041512.IAA22056@webmail.speakeasy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thanks in advance,
Tom Sattler

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-05-04 15:26:46 Re: time calculations
Previous Message Oliver Vecernik 2001-05-04 14:48:19 time calculations