honeysql

Discussion of https://github.com/seancorfield/honeysql :slightly_smiling_face:
viesti 2020-11-25T07:00:38.219Z

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])

viesti 2020-11-25T07:28:54.219600Z

I guess what's missing is the extra dimensions in the insert statement