PreparedStatement for set membership (The IN operator) - Mailing list pgsql-jdbc

From Daron Ryan
Subject PreparedStatement for set membership (The IN operator)
Date
Msg-id 4D9AC223.4000602@gmail.com
Whole thread Raw
Responses Re: PreparedStatement for set membership (The IN operator)  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: PreparedStatement for set membership (The IN operator)  (Thomas Markus <t.markus@proventis.net>)
List pgsql-jdbc
  Hello,

I need to use a SELECT statement with varying data for set membership. IE.

SELECT link_id
FROM links
WHERE heading_id IN (?, ?, ?)

It won't always be the same number of members in the set. I am using an
ordinary statement with an executeQuery call but would prefer to use a
PreparedStatement. Is this possible? If so how do I set the values in
the set?

Regards,
Daron.

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: [pgsql-jdbc] Daily digest v1.2821 (7 messages)
Next
From: Heikki Linnakangas
Date:
Subject: Re: PreparedStatement for set membership (The IN operator)