expression IN value list - Mailing list pgsql-jdbc

From Andy Kriger
Subject expression IN value list
Date
Msg-id OJEFIHHAALOBKKJEOMBDEEPAFKAA.akriger@greaterthanone.com
Whole thread Raw
List 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


pgsql-jdbc by date:

Previous
From: Paul Thomas
Date:
Subject: Re: XA datasource for PostgreSQL
Next
From: James Robinson
Date:
Subject: JBoss w/int8 primary keys in postgres ...