BUG #6155: literal definition of arrays with double qoutes leads to error

Поиск
Список
Период
Сортировка
От listar
Тема BUG #6155: literal definition of arrays with double qoutes leads to error
Дата
Msg-id 201108082022.p78KM2jZ050528@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6155: literal definition of arrays with double qoutes leads to error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      6155
Logged by:          listar
Email address:      listar@mail.ru
PostgreSQL version: 8.4.5
Operating system:   Gentoo 4.4.4-r2 p1.3, pie-0.4.5 64-bit
Description:        literal definition of arrays with double qoutes leads to
error
Details:

for example:
SELECT ('{string "with" double quotes}'::text[])[1] as value;
gives:

ERROR:  malformed array literal: "{string "with" double quotes}"
LINE 1: SELECT ('{string "with" double quotes}'::text[])[1] as value...
                ^
********** Error **********
ERROR: malformed array literal: "{string "with" double quotes}"
SQL state: 22P02
Character: 9

Expected result:
         value
---------------------------
string "with" double quotes
(1 row)


I tried to escape input string in different ways, but it wasn't successful
=(

as I can understood the problem is in "switch" statement in method
"ArrayCount(...)" in file \src\backend\utils\adt\arrayfuncs.c
(that switch doesn't cover all possible cases)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6154: wrong result with nested left-joins
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6154: wrong result with nested left-joins