Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-patchespgsql-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: current.80.diff
Description: text/x-patch (6.1 KB)

In response to

Responses

pgsql-patches by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group