Обсуждение: BUG #6499: query to get data with single quote

The following bug has been logged on the website:

Bug reference:      6499
Logged by:          Sujatha
Email address:      sujatha.pelluru@gmail.com
PostgreSQL version: 9.1.3
Operating system:   Linux
Description:=20=20=20=20=20=20=20=20

Hi

I have column(string datatype) has a data starting with single quote as
below

'single resource to avoid all job execution'=20

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.

Please suggest me how I can frame query.

Thanks
Sujatha

<sujatha.pelluru@gmail.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