IN question

From: "Eric Walstad" <eric(at)ericwalstad(dot)com>
To: sfpug(at)postgresql(dot)org
Subject: IN question
Date: 2008-12-09 22:36:37
Message-ID: c436fcd20812091436u7d5da4bbv9eb87e53b4772fd8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

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.

Responses

Browse sfpug by date

  From Date Subject
Next Message Meredith L. Patterson 2008-12-09 22:43:21 Re: IN question
Previous Message Josh Berkus 2008-12-05 22:00:01 Re: First Bay Area Interpreted Languages Holiday Party!