From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | text array |
Date: | 2002-02-07 00:35:25 |
Message-ID: | Pine.LNX.4.33.0202061634580.2327-100000@visor.corp.nextbus.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Perhaps someone can shed light on this problem we are seeing.
In a table on Postgresql 7.2.b2, we have a table with one of the columns defined as
text[7]. If you select * from tab1, this columns data comes out as this:
yada | yoda | {"wkend","wkd","wkd","wkd","wkd","wkd","wkend"}
Then we dump and restore into a table with the exact same schema (this
column is a text[7]) but now when you select data from the table is comes
out looking like this:
yada | yoda | {wkend,wkd,wkd,wkd,wkd,wkd,wkend}
Was the handling of arrays changed in this latest release of the server?
Specifically, we have a java program that reads this table data and expects
it returned with the double quotes. It is now failing.
Any information on this would be helpful.
Thanks,
--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-02-07 00:37:02 | Re: [HACKERS] [Fwd: MS SQL compatible functions] |
Previous Message | Peter Eisentraut | 2002-02-07 00:28:12 | Summary of new configuration file and data directory locations |