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

From: "listar" <listar(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6155: literal definition of arrays with double qoutes leads to error
Date: 2011-08-08 20:22:02
Message-ID: 201108082022.p78KM2jZ050528@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6155
Logged by: listar
Email address: listar(at)mail(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-08-09 04:53:20 Re: BUG #6154: wrong result with nested left-joins
Previous Message Tom Lane 2011-08-08 18:11:17 Re: BUG #6154: wrong result with nested left-joins