Re: no quotes in arrays in 7.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: no quotes in arrays in 7.2
Date
Msg-id 7122.1016656784@sss.pgh.pa.us
Whole thread Raw
In response to no quotes in arrays in 7.2  (Peter Keller <peter.keller@bvv.bayern.de>)
List pgsql-general
Peter Keller <peter.keller@bvv.bayern.de> writes:
> Only using a comma as a separator is not very good, because the text in the
> array can contain commas, so seperating can get impossible.

If there are any commas then the value will be quoted.

> Is the new output a bug?

I don't think so.  The point was to avoid quoting numeric elements while
fixing the extremely broken rule that array_out used to use to decide
whether to quote or not.  The new rule is to look at the text to decide
if it needs any quotes.

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: ERROR:B heap_delete: (am)invalid tid
Next
From: Tom Lane
Date:
Subject: Re: dbase restore