[joppy]

Arrays are nicer for the IN case because Postgres does not understand an empty list, i.e “WHERE foo IN ()” will error. Using the “WHERE foo = ANY(array)” works as expected with empty arrays.

[grantwu]

Works as expected? Wouldn't that WHERE clause filter out all of the rows? Is that frequently desired behavior?

[ethanpailes]

I could imagine that you're building up the array in go code and want the empty set to be handled as expected.