Clojurians Log v2

Hi, I have this HugSql query:

-- :name find-friendships :? :*
-- :doc find all friends for a given user
select (u.id, u.first_name, u.last_name) from friendships
join users u on u.id = friendships.user2
where user1 = :user_id

-- Let's specify some columns with the
-- identifier list parameter type :i* and
-- use a value list parameter type :v* for SQL IN()
-- :name characters-by-ids-specify-cols :? :*
-- :doc Characters with returned columns specified
select :i*:cols from characters
where id in (:v*:ids)

Why the parentheses around your selected columns? This is creating a tuple, I think. Can you change your SQL to select u.id, u.first_name, u.last_name from…?

That worked… Thanks!

You’re welcome!

Love it when it’s something simple like that