Re: no quotes in arrays in 7.2
От | Stephan Szabo |
---|---|
Тема | Re: no quotes in arrays in 7.2 |
Дата | |
Msg-id | 20020320084117.P45997-100000@megazone23.bigpanda.com обсуждение исходный текст |
Ответ на | no quotes in arrays in 7.2 (Peter Keller <peter.keller@bvv.bayern.de>) |
Список | pgsql-general |
On Wed, 20 Mar 2002, Peter Keller wrote: > 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. If the string contained a comma it should get quotes put around it on output: sszabo=# create table aat(a text[]); insert into aCREATE sszabo=# insert into aat values ('{"aaa", "fdadfa,fdad", "3"}'); INSERT 148041 1 sszabo=# select * from aat; a ----------------------- {aaa,"fdadfa,fdad",3} (1 row) > Is the new output a bug? Maybe (see recent discussion on the topic)
В списке pgsql-general по дате отправления: