no quotes in arrays in 7.2

From: Peter Keller <peter(dot)keller(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: no quotes in arrays in 7.2
Date: 2002-03-20 15:32:23
Message-ID: 200203201431.PAA14163@va45s03.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I upgraded to pg 7.2.
When I do a SELECT on a column defined as text[ ] I get:

{{FLTL,DFBV2bI16nfqCEag,1000}}

when I do the same SELECT on postgres 7.1 I get the same result but with
quotes:

{{"FLTL","DFBV2bI16nfqCEag","1000"}}

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.
Is the new output a bug?

Peter
--
Bezirksfinanzdirektion Muenchen
Vermessungsabteilung
...............................................................................................
Peter Keller : Tel: (+49) 089-2190-2594
Alexandrastr. 4 : Fax: (+49) 089-2190-2459
(Liebigbau) : mailto:Peter(dot)Keller(at)bvv(dot)bayern(dot)de
80538 Muenchen : web: http://www.bayern.de/vermessung

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-03-20 15:55:02 Re: Auomatic numbering, replacing nulls and IF
Previous Message Gregory Wood 2002-03-20 15:32:09 Re: Auomatic numbering, replacing nulls and IF