Re: problem with array of boxes

At 18:01h -0500 16.03.2002, Tom Lane wrote:
>I've finished looking into this, and the short answer is that your input
>is not syntactically correct. Because type box has typdelim = ';', the
>correct input would have been
>
>INSERT INTO boxarray_test VALUES ('{"(3,3),(1,1)";"(4,4),(2,2)"}');

Thanks! I changed my code to use a semi-colon instead of a comma as
delimiter and that indeed solved my problem.

>This still leaves us with the question of whether it's really a good
>idea that type box has typdelim ';' and not ',' like everything else
>uses. Anyone have a strong feeling about changing it or not?

I'm relatively new to PostgreSQL, so I don't have a qualified opinion on this.

-Andre

--
Andre Radke + mailto:lists(at)spicynoodles(dot)net + http://www.spicynoodles.net/