Postgres Pro
Downloads
Home   >   mailing lists

ignore single character in SELECT query? - Mailing list pgsql-sql

From jspring@gmail.com
Subject ignore single character in SELECT query?
Date
Msg-id 1113360363.473080.314360@z14g2000cwz.googlegroups.com
Whole thread Raw
Responses Re: ignore single character in SELECT query?  (Greg Stark <gsstark@mit.edu>)
Re: ignore single character in SELECT query?  ("Dinesh Pandey" <dpandey@secf.com>)
List pgsql-sql
Tree view 
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?

pgsql-sql by date:

Previous
From: "A. R. Van Hook"
Date:
Subject: max question
Next
From: "Ilya A. Kovalenko"
Date:
Subject: operating "inet" type