Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

sfpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group