RFC: array literal syntax - Mailing list pgsql-general

From Joe Conway
Subject RFC: array literal syntax
Date
Msg-id 4115213F.7070806@joeconway.com
Whole thread Raw
Responses Re: RFC: array literal syntax  (Guy Fraser <guy@incentre.net>)
List pgsql-general
In Postgres 7.4 and earlier you can do the following:

select '{{"1 2" x},{3}}'::text[];
       text
-----------------
  {{"1 2 x"},{3}}
(1 row)

I regard this as a bug, and am contemplating commiting a fix this
weekend against 8.0devel. However it was brought up on HACKERS that
since this has always been allowed, it might be viewed by some as a
feature, not a bug. With the proposed change, it would look like this:

select '{{"1 2" x},{3}}'::text[];
ERROR:  malformed array literal: "{{"1 2" x},{3}}"

Any comments for or against calling this a bug? Now's the time to speak
up, particularly if you depend on this as a feature.

Thanks,

Joe

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Rounding in PGSQL
Next
From: David Garamond
Date:
Subject: Writing regex in PL's