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: (view raw, whole thread or download thread mbox)
Lists: sfpug

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

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.




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-2017 The PostgreSQL Global Development Group