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