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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Kristian Lance 2001-11-29 18:06:51 SQL Query Problem
Previous Message Manish Khare 2001-11-29 13:00:07 Error in Installation