From: | Amin Abdulghani <amin(at)quantiva(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres 7.2.1 parse bug |
Date: | 2002-07-25 20:01:00 |
Message-ID: | web-725533@quantiva.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Stoessel | 2002-07-25 20:01:26 | Re: MySQL vs. PostgreSQL |
Previous Message | Andrew Sullivan | 2002-07-25 19:42:13 | archives dead again? |