pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: tsattler@speakeasy.net
To: pgsql-admin@postgresql.org
Subject: Queries
Date: Fri, 4 May 2001 08:12 -0700
Message-ID: <200105041512.IAA22056@webmail.speakeasy.net> (raw)

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



view thread (7+ messages)  latest in thread

Message-ID: <200105041512.IAA22056@webmail.speakeasy.net>
Permalink:  ../200105041512.IAA22056@webmail.speakeasy.net/
Also on:    postgresql.org/message-id/200105041512.IAA22056@webmail.speakeasy.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tsattler@speakeasy.net
  Subject: Re: Queries
  In-Reply-To: <200105041512.IAA22056@webmail.speakeasy.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox