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

From: Joe Conway <mail(at)joeconway(dot)com>
To: Markus Bertheau <twanger(at)bluetwanger(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: array_in: '{}}'::text[]
Date: 2004-08-23 18:32:44
Message-ID: 412A384C.5000907@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches 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
---------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.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

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-08-23 19:02:50 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE
Previous Message Magnus Hagander 2004-08-23 18:16:18 Win32 fix: Token buffer

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2004-08-23 21:06:00 Re: reply to setting
Previous Message Sascha Ziemann 2004-08-23 17:08:03 CREATE TYPE VARCHAR2