Skip site navigation (1) Skip section navigation (2)

Re: Bug #524: Bad quoting of backslash in text arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ondrap(at)penguin(dot)cz, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #524: Bad quoting of backslash in text arrays
Date: 2001-11-29 14:56:22
Message-ID: 18377.1007045782@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> Note that the backslash between aaa and bbb should be doubled.

Yeah, I think you're right.  I get:

regression=# select a from test;
        a
------------------
 {"aaa\bbb\"ccc"}
(1 row)

regression=# select a[1] from test;
      a
-------------
 aaa\bbb"ccc
(1 row)

If the array output routine is going to backslash the ", methinks it'd
better backslash the backslash too.

Any objections to changing this behavior?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Kristian LanceDate: 2001-11-29 18:06:51
Subject: SQL Query Problem
Previous:From: Manish KhareDate: 2001-11-29 13:00:07
Subject: Error in Installation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group