BUG #6499: query to get data with single quote - Mailing list pgsql-bugs

From sujatha.pelluru@gmail.com
Subject BUG #6499: query to get data with single quote
Date
Msg-id E1S33i4-0008TT-5h@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #6499: query to get data with single quote  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: thomas.pasch@nuclos.de
Date:
Subject: BUG #6500: Installer does not honour --serverport
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #6499: query to get data with single quote