Re: array_in: '{}}'::text[] - Mailing list pgsql-sql

From Joe Conway
Subject Re: array_in: '{}}'::text[]
Date
Msg-id 412A384C.5000907@joeconway.com
Whole thread Raw
In response to array_in: '{}}'::text[]  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
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 :(

regression=# SELECT '{}}'::text[]; text
------ {}
(1 row)

regression=# select version();                                                       version
---------------------------------------------------------------------------------------------------------------------
PostgreSQL8.0.0beta1 on x86_64-unknown-linux-gnu, compiled by GCC gcc 
 
(GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7)
(1 row)

Look for a fix soon, at a cvs repository near you....

Joe


pgsql-sql by date:

Previous
From: "Cavit Keskin"
Date:
Subject: TSearch2 other languages
Next
From: Joe Conway
Date:
Subject: Re: reply to setting