Hey! How should I insert empty array to column of type json[]
?
I think its 50% honeysql, 50% postgres question: I don’t know how to do that even in plain sql 🙂
I tried
{:order_id order_id
:route (sql/raw (str route "::jsonb[]"))}
And it produces [“INSERT INTO routes (order_id, route) VALUES (?, []::jsonb[]) RETURNING id, route, order_id” 1506] and I get invalid syntax error at or near "["
oh, forget it, I had some clojure syntax problems 😞