hugsql 2022-12-05 | Slack Archive

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!

2022-12-05