array_in: "{}}"::text[]

Is there a reason the array_in parser accepts additional closing braces
at the end?

oocms=# SELECT '{}}'::text[];
text
------
{}
(1 запись)

Thanks

--
Markus Bertheau


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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

В Пнд, 23.08.2004, в 13:45, Markus Bertheau пишет:
> Is there a reason the array_in parser accepts additional closing braces
> at the end?

In fact it seems to accept everything after the closing brace matching
the first opening brace.

Thanks

--
Markus Bertheau


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

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

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html