Fork me on GitHub
#sql
<
2020-03-19
>
Jivago Alves16:03:49

Greeting folks! We’re using next.jdbc in our app. Is there a way to “automagically” turn Clojure vectors into Postgres’ array type and vice-versa? We’ve done that for jsonb , however I can’t find any example for array in the docs. Thanks!

seancorfield17:03:08

@jivagoalves Look at SettableParameter and ReadableColumn protocols in the docs. There's an example for json/`jsonb` in the Tips &amp; Tricks page -- something similar should work for vectors/PG arrays.

Jivago Alves19:03:46

We’ll take a look at that. Thanks @seancorfield!