postgres 7.2.1 parse bug
От | Amin Abdulghani |
---|---|
Тема | postgres 7.2.1 parse bug |
Дата | |
Msg-id | web-725533@quantiva.com обсуждение исходный текст |
Ответы |
Re: postgres 7.2.1 parse bug
Re: postgres 7.2.1 parse bug |
Список | pgsql-general |
Hi, Apparently there seems to be a parsing bug in 7.2.1 ( though it seems to be OK in 7.2)when inserting into array columns. The bug seems to be that if an array element is quoted with "" followed by spaces before the comma (for the next element), the extra space becomes part of the text for the element. As an example consider the following (testa is a table with a single column data of type text[]) (Note the space after bob and space after the first null string.) netwait_db=# insert into testa values('{"bob" ,"moo","" ,"","theend"}'); INSERT 22317950 1 netwait_db=# insert into testa values('{"Bob","moo","","","theend"}'); INSERT 22317953 1 netwait_db=# select * from testa; data ---------------------------- {"bob ",moo," ","",theend} {Bob,moo,"","",theend} (2 rows) netwait_db=# Thanks.. Amin
В списке pgsql-general по дате отправления: