Re: Array of box not supported?
От | Tom Lane |
---|---|
Тема | Re: Array of box not supported? |
Дата | |
Msg-id | 12630.1297876679@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Array of box not supported? (RW Shore <rws228@gmail.com>) |
Ответы |
Re: Array of box not supported?
|
Список | pgsql-jdbc |
RW Shore <rws228@gmail.com> writes: > 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)"} For historical reasons (well, I can see why they did it, but it's still weird), array of box uses semicolon not comma as the delimiter between array elements. regression=# select '{"1.0,1.0,0.0,0.0","10.0,10.0,0.0,0.0"}'::box[]; ERROR: malformed array literal: "{"1.0,1.0,0.0,0.0","10.0,10.0,0.0,0.0"}" LINE 1: select '{"1.0,1.0,0.0,0.0","10.0,10.0,0.0,0.0"}'::box[]; ^ regression=# select '{"1.0,1.0,0.0,0.0";"10.0,10.0,0.0,0.0"}'::box[]; box ----------------------------- {(1,1),(0,0);(10,10),(0,0)} (1 row) The advantage is you don't need double quotes: regression=# select '{1.0,1.0,0.0,0.0;10.0,10.0,0.0,0.0}'::box[]; box ----------------------------- {(1,1),(0,0);(10,10),(0,0)} (1 row) Whether this requires any special pushups on the JDBC side is beyond my ken. regards, tom lane
В списке pgsql-jdbc по дате отправления: