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)
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 |