Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: <jspring@gmail.com>, <pgsql-sql@postgresql.org>
Subject: Re: ignore single character in SELECT query?
Date: Wed, 13 Apr 2005 10:28:44 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-reply-to: <1113360363.473080.314360@z14g2000cwz.googlegroups.com>
Thread-Index: AcU/43c0iggUcxP1RnmE4LZW6F81LQAAK6ug
Message-Id: <20050413050207.35CB753415@svr1.postgresql.org>

Use
--------
select replace(quote_literal('don\'t'), '\'', '');
Or
select replace(quote_ident(myColumnName, '\'', '');

Thanks
Dinesh Pandey


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of jspring@gmail.com
Sent: Wednesday, April 13, 2005 8:16 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] ignore single character in SELECT query?

Given select criteria "dont" I would like to return rows with values
"don't".  Or similarily I want rows with "they're" given input criteria
"theyre".

So basically I want to ignore a single character (the apostrophe
character), anywhere in the middle of my search word, in selecting
results.  How can I do this?


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly