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

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