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

2006-01-20 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > The number of expressions. If you set max_expr_depth to 10 then > ten 1-character values cause an error but nine 1-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 l

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

2006-01-20 Thread Michael Fuhr
On Fri, Jan 20, 2006 at 02:41:04PM +, 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 1-character

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

2006-01-19 Thread Michael Fuhr
On Fri, Jan 20, 2006 at 01:49:03AM +, frank church wrote: > What is the maximum length of an IN(a,b,cd) list in PostgreSQL? > > I am using 7.4. In 7.4 and earlier it depends on the max_expr_depth setting. http://www.postgresql.org/docs/7.4/static/runtime-config.html#RUNTIME-CONFIG-CLIENT

[GENERAL] What is the maximum length of an IN(a,b,c....d) list in PostgreSQL

2006-01-19 Thread frank church
What is the maximum length of an IN(a,b,cd) list in PostgreSQL? I am using 7.4. This message was sent using IMP, the Internet Messaging Program. ---(end of broadcast)--- TIP 3: