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)



--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc