Postgres Pro
Downloads
Home   >   mailing lists

Queries - Mailing list pgsql-admin

From tsattler@speakeasy.net
Subject Queries
Date
Msg-id 200105041512.IAA22056@webmail.speakeasy.net
Whole thread Raw
Responses Re: Queries  (Joel Burton <jburton@scw.org>)
List pgsql-admin
Tree view 
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
therea way I can do that?  Is that what the "ilike" function does? 

I'm on 7.0.3.

Thanks in advance,
Tom Sattler

pgsql-admin by date:

Previous
From: Dmitry Morozovsky
Date:
Subject: [possibly] dumb question
Next
From: "Ligia Pimentel"
Date:
Subject: Problem connecting from pgadmin: CACHE LOOKUP FOR USER XX FAILED