pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: postgresql <pgsql@symcom.com>
Cc: Megalex <megalex@klanomega.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: problems with single quotes..
Date: Sun, 2 Dec 2001 21:23:41 -0800 (PST)
Message-ID: <20011202212229.C86964-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <200112030308.fB338em54420@postgresql.org>

On Sun, 2 Dec 2001, postgresql wrote:

> but this is exactally correct behavior.....you can use either two single quotes to
> escape the quote or the backslash so.....
>
>  '  ''   \\   ''   '
> singlequote to start the sequence(string)
> two singlequotes to insert an escape then a singlequote (yields a single quote)
> a backslash to escape the following backslash (yields a single backslash)
> two singlequotes to insert an escape then a singlequote (yields a single quote)
> then ended by a single quote
>
> this is acting correctly.....

Yes.  I'm assuming that '\' was what he wanted out, so I gave
the sequence that worked for me.  He said he'd tried escaping
the backslash and didn't have it work, but I'm not sure what
he meant by that.




view thread (12+ messages)  latest in thread

Message-ID: <20011202212229.C86964-100000@megazone23.bigpanda.com>
Permalink:  ../20011202212229.C86964-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20011202212229.C86964-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, pgsql@symcom.com, megalex@klanomega.com
  Subject: Re: problems with single quotes..
  In-Reply-To: <20011202212229.C86964-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox