humdum, having trouble while inserting data into table with a multi-dimensional array column
create table my_table (
array_data double precision[][]
)
(next.jdbc/execute! db
(hsql/format (-> (sql/insert-into :my_table)
(sql/values [{:array_data (honeysql.types/array [[1 1] [2 2]])}]))))
gives
Execution error (PSQLException) at org.postgresql.core.v3.QueryExecutorImpl/receiveErrorResponse (QueryExecutorImpl.java:2440).
ERROR: syntax error at or near "$2"
Position: 52
the sql generated is
2020-11-25 06:58:58.620 UTC [8290] ERROR: syntax error at or near "$2" at character 52
2020-11-25 06:58:58.620 UTC [8290] STATEMENT: INSERT INTO my_table (array_data) VALUES (ARRAY[$1 $2, $3 $4])
I guess what's missing is the extra dimensions in the insert statement