Hello I’m trying to use IN operation but getting error : org.postgresql.util.PSQLException: Can't infer the SQL type to use for an instance of clojure.lang.PersistentVector

hi @cksharma122, can you copy your code?

Sorry I cannot but I can give you an example how my code looks like

yes, basically just make sure you have specified a value lists on the sql expression

something like

select * from characters where name in (:v*:names)

where names is the name of your parameter

:names can be list or a vector right?

as long as you specified that is a value list, i dont’ think there is something else you need to do .

Let me see once again. Thank you for the suggestion

you can find an example on the docs https://www.hugsql.org/#param-value-list

Will it not work if I pass a vector instead of list?

it should work