expression IN value list

From: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
To: "Pgsql-Jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: expression IN value list
Date: 2003-09-05 21:59:35
Message-ID: OJEFIHHAALOBKKJEOMBDEEPAFKAA.akriger@greaterthanone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Does anyone know how to setup this query using a PreparedStatement?

DELETE FROM table WHERE id IN (list of values)

Would it be significantly faster to do a query like this (where there could
be hundreds of values) versus running the DELETE separately for each value
(opening a new db connection each time)?

thx
andy

Browse pgsql-jdbc by date

  From Date Subject
Next Message James Robinson 2003-09-06 18:38:40 JBoss w/int8 primary keys in postgres ...
Previous Message Paul Thomas 2003-09-05 17:35:20 Re: XA datasource for PostgreSQL