In mysql or postgres, is there a limit to the size of an IN (1,2,n) statement?
- by Kyle
I've got quite a few SQL statements like such:
SELECT foo FROM things WHERE user_id IN (1,2,3..n)
Is there a known limit to the number of elements that will safely fit in an IN clause like that?