| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <sujatha(dot)pelluru(at)gmail(dot)com>,<pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #6499: query to get data with single quote |
| Date: | 2012-03-01 16:58:56 |
| Message-ID: | 4F4F56700200002500045D63@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
<sujatha(dot)pelluru(at)gmail(dot)com> wrote:
> I have column(string datatype) has a data starting with single
> quote as below
>
> 'single resource to avoid all job execution'
>
> Now I want write select query to select records which starts with
> single quote.
>
> I tried with many option however could not get the result.
This is not a bug. For help with a question like this, please send
an email to one of the other lists, like pgsql-general or
pgsql-novice.
http://www.postgresql.org/community/lists/
To include an apostrophe in a string literal, double it. Try:
SELECT * FROM tblname WHERE colname LIKE '''%';
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | thomas.pasch | 2012-03-01 18:50:48 | BUG #6501: postgresql-9.1.3-1-linux.run does not install on 64bit system |
| Previous Message | thomas.pasch | 2012-03-01 16:08:50 | BUG #6500: Installer does not honour --serverport |