IN question

["Eric Walstad" <eric(at)ericwalstad(dot)com>]

Hi,

I wasn't able to find an answer after googling.  What is the maximum
limit to the number of elements allowed in an IN list in PostgreSQL
8.1?

SELECT foo FROM bar WHERE fizz IN (0, 1, 2, 3...<max?>);

The results I found suggest the limit is based on available memory but
I didn't find anything definitive.

Thanks,

Eric.