Re: Select where id in (LARGE LIST) ?

Jasper Potts wrote:
> I know from when I was testing "SELECT ... WHERE id IN (...,...)" I got
> a buffer over flow or similar exception from the postgresql native
> process at about 200-300 longs in the IN clause.

Well I'd need to see the actual exception not a vague description of it
to comment further.

> Could do with finding
> what the real limits are so I can protect against it. I will have a dig
> though the documentation later see what I can find :-)

There may be a (backend) limit on the number of parameters in a query,
not sure.

-O