Binding Parameter As Postgresql Array

I'm trying to bind a prepared statement parameter which is a 'multidimensional' PostgreSQL array. Here's an array example (column type is numeric[]): {{1,10},{2,20}} How do I bind

Solution 1:

Try something like this (untested):

                ------------------ your connection
                V
Array inArray = conn.createArrayOf("integer", newInteger[][] {{1,10},{2,20}});
stmt.setArray(1, inArray);

Links:

• Postgres and multi-dimensions arrays in JDBC
• Passing Array from Java to Postgres