postgres 7.2.1 parse bug

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

Responses

Browse pgsql-general by date

  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?