Postgres Pro
Downloads
Home   >   mailing lists

Array of box not supported? - Mailing list pgsql-jdbc

From RW Shore
Subject Array of box not supported?
Date
Msg-id AANLkTin8UAg6PXScMjnkYMzq3Ud5HuFZBOazmh466cCp@mail.gmail.com
Whole thread Raw
Responses Re: Array of box not supported?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tree view
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?

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function
Next
From: Lukas Eder
Date:
Subject: Re: [HACKERS] Fwd: Weird issues when reading UDT from stored function