Re: no quotes in arrays in 7.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: no quotes in arrays in 7.2
Date: 2002-03-20 20:39:44
Message-ID: 7122.1016656784@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Stoessel 2002-03-20 20:48:48 Re: zerofill: lost my leading zeroes
Previous Message Jan Wieck 2002-03-20 20:36:09 Re: ERROR:B heap_delete: (am)invalid tid