Re: Problem with very big queries. - Mailing list pgsql-jdbc

Panagiotis Papadakos wrote:
> Hello everybody.
>
> I want to send to postgresql-8.0 a very big query,
> select * from table where lala IN (....)
> Inside IN there are almost 60000 values.
>


I think I'd put those 60000 values in their own table, and use some sort
of join.

    select t.f1,t.f2 from table as t, table2 as b WHERE t.lala = b.lala;

or something like that.  (i'm lousy at figuring out joins)