Hello! So to avoid having to convert the data type at the Clojure level I'm frequently setting the type of my ids using hugsql integer, for example
- :name list-all-tasks :? :*
-- :doc list all task deets for a page
select * from task
where page_ref = :page_ref::integer
However, not sure how I can do that with a vector like:
(:v*:task_ids)
I'm afk but doesn't (:v*:task_ids::integer) work?
If you're using postgresql, instead of page_ref in (:v*:task_ids) use page_ref = any(array[:v*:task_ids]::integer[]).
That works Curtis. Great!