Re: What is the maximum length of an IN(a, b, c....d) list in PostgreSQL

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: frank church <pgsql(at)adontendev(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the maximum length of an IN(a, b, c....d) list in PostgreSQL
Date: 2006-01-20 17:29:30
Message-ID: 20060120172930.GA39421@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 20, 2006 at 02:41:04PM +0000, frank church wrote:
> Is the value the actual length of the IN string, or is the maximum of the comma
> separated exressions?

The number of expressions. If you set max_expr_depth to 10 then
ten 1-character values cause an error but nine 10000-character
values should be fine (tested on my 7.4.11 system). I think the
same applies to 8.0 and later with max_stack_depth: the limit depends
on the number of expressions, not on the lengths of the elements.
At least that's what my tests seem to show.

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2006-01-20 17:49:54 Re: sequences not restoring properly
Previous Message Brian Dimeler 2006-01-20 17:26:42 sequences not restoring properly