5 ms·
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
by joppy 5y ago
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 5y agoWorks as expected? Wouldn't that WHERE clause filter out all of the rows? Is that frequently desired behavior?
- ethanpailes 5y agoI could imagine that you're building up the array in go code and want the empty set to be handled as expected.