"Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> writes:
> Now the sql is OK but now I have the following error:
> ERROR: stack depth limit exceeded
> SQL state: 54001
> Hint: Increase the configuration parameter "max_stack_depth".
> In the previous e-mail I hide the numbers of itens of my set
> (in(234,12332,1232,....) actually I have more than 36000 subsets of my IN
> statement.
That's probably well past the point at which you should expect IN (list)
to give reasonable performance. Instead consider putting the values
into a temp table and writing a join or IN (subselect) against the temp table.
regards, tom lane