Re: [SQL] array_in: '{}}'::text[]

From: Joe Conway <mail(at)joeconway(dot)com>
To:
Cc: Markus Bertheau <twanger(at)bluetwanger(dot)de>, "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [SQL] array_in: '{}}'::text[]
Date: 2004-08-27 20:37:57
Message-ID: 412F9BA5.8070009@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches pgsql-sql

Joe Conway wrote:
> Markus Bertheau wrote:
>
>> Is there a reason the array_in parser accepts additional closing braces
>> at the end?
>>
>> oocms=# SELECT '{}}'::text[];
>> text
>> ------
>> {}
>> (1 запись)
>
>
> Hmmm, I was *about* to say that this is fixed in cvs (and indeed, the
> array_in parser is significantly tightened up compared to previous
> releases), but unfortunately, there is still work to be done :(

The attached patch takes care of the above issue:

regression=# SELECT '{}}'::text[];
ERROR: malformed array literal: "{}}"

If there are no objections, I'll apply in about 24 hours.

Joe

Attachment Content-Type Size
current.80.diff text/x-patch 6.1 KB

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Ed L. 2004-08-27 21:14:27 Re: log_filename_prefix --> log_filename + strftime()
Previous Message Tom Lane 2004-08-27 20:15:34 Re: log_filename_prefix --> log_filename + strftime()

Browse pgsql-sql by date

  From Date Subject
Next Message Artimenko Igor 2004-08-27 20:53:38 Re: Copy command freezes but INSERT works fine with trigger on insert.
Previous Message Gregory S. Williamson 2004-08-27 20:29:52 Re: Copy command freezes but INSERT works fine with trigger oninsert.