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
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 |