finding strings with quotes

From: Christine Penner <chris(at)fp2(dot)ca>
To: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: finding strings with quotes
Date: 2011-02-25 20:45:10
Message-ID: 4D6814D6.9000507@fp2.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to do a select to find on a char field that has a single
quote but getting errors. This is what I'm doing:

Select * from f_buildings where B_STRET_LNE_CON='BERLETT\'S ROAD'

The text I'm trying to find is BERLETT'S ROAD

If I do the same thing but have double quotes in the string instead of
single quotes this works.

--
Christine Penner
Ingenious Software
250-352-9495
chris(at)fp2(dot)ca

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-02-25 21:56:04 Re: pgAdmin3 Issue
Previous Message Rich Shepard 2011-02-25 20:37:17 Re: pgAdmin3 Issue