problem with array of boxes

From: Andre Radke <lists(at)spicynoodles(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: problem with array of boxes
Date: 2002-03-14 16:00:20
Message-ID: p05100303b8b67225fc74@[192.168.1.5]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


Hello!

I have run into a problem with the array of boxes datatype. Here is a
simple example:

testdb=# CREATE TABLE boxarray_test (col1 BOX[2]);
CREATE

testdb=# INSERT INTO boxarray_test VALUES ('{"(3,3),(1,1)","(4,4),(2,2)"}');
INSERT 32957 1

testdb=# SELECT * FROM boxarray_test;
col1
---------------
{(4,4),(2,2)}
(1 row)

Instead of the above, I expected the result of the SELECT to be:

{"(3,3),(1,1)","(4,4),(2,2)"}

Arrays of other geometric types worked like I expected them to do.

Is this a bug?

I'm running PostgreSQL 7.2 on Mac OS X 10.1.3
(powerpc-apple-darwin5.3), compiled by GCC 2.95.2. I ran the
regression tests against my installation and all tests were completed
successfully. (The tests don't seem to cover arrays of geometric
types, though.)

-Andre

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Smith 2002-03-14 16:12:49 Re: JDBC Prepared Statement Bug
Previous Message Tom Lane 2002-03-14 16:00:04 Re: Question about function

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2002-03-14 16:05:08 Re: [HACKERS] problems with Tomcat and postgres
Previous Message Tom Lane 2002-03-14 15:54:07 Re: about BufferPoolBlowaway()