Couldn't handle an integer array with hugsql about hugsql HOT 1 CLOSED

@monstasat In order to use Postgresql arrays, you need to create an array object type that the Postgresql JDBC driver understands to be a PG array. Below is an example of this using db-run instead of separate sql & clj. The db is a db spec and the jdbc/ is clojure.java.jdbc:

(let [db (:postgresql dbs)
      cn (jdbc/get-connection db)]
      (hugsql/db-run db "create table t1 (id integer, arr integer[])" {} :!)
      (hugsql/db-run db "insert into t1 (id) values (1)" {} :!)
      (hugsql/db-run db "update t1 set arr = :arr where id = 1" 
        {:arr (.createArrayOf cn "integer" (into-array Long [1 2 3]))} :!))

I think most folks probably create a function to take a Clojure vector of integers and return the needed array object.

from hugsql.