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/
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 |
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() |