Array of box not supported?

From: RW Shore <rws228(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Array of box not supported?
Date: 2011-02-16 16:25:47
Message-ID: AANLkTin8UAg6PXScMjnkYMzq3Ud5HuFZBOazmh466cCp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

To insert into a box[ ], I need to convert the individual boxes into a
string. I get a "malformed array literal" error with any of the following
formats for a 1 dimensional array with two boxes:

{"1.0,1.0,0.0,0.0","10.0,10.0,0.0,0.0"}
{"((1.0,1.0),(0.0,0.0))","((10.0,10.0),(0.0,0.0))"}
{"(1.0,1.0),(0.0,0.0)","(10.0,10.0),(0.0,0.0)"}

Can anybody suggest other things to try, or do I conclude that box[ ] isn't
supported?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2011-02-16 17:17:59 Re: Array of box not supported?
Previous Message Tom Lane 2011-02-16 15:23:43 Re: Fwd: [JDBC] Weird issues when reading UDT from stored function