PreparedStatement for set membership (The IN operator)

Поиск
Список
Период
Сортировка
От Daron Ryan
Тема PreparedStatement for set membership (The IN operator)
Дата
Msg-id 4D9AC223.4000602@gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Jowett
Дата:
Сообщение: Re: [pgsql-jdbc] Daily digest v1.2821 (7 messages)
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PreparedStatement for set membership (The IN operator)