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  (Amin Abdulghani <amin@quantiva.com>)
Re: postgres 7.2.1 parse bug  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: archives dead again?
Следующее
От: Vincent Stoessel
Дата:
Сообщение: Re: MySQL vs. PostgreSQL