<sujatha.pell...@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
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
