PreparedStatement for set membership (The IN operator)

Поиск
Список
Период
Сортировка
Искать
От
Daron Ryan
Тема
PreparedStatement for set membership (The IN operator)
Дата
Msg-id
4D9AC223.4000602@gmail.com
Список
Дерево обсуждения
PreparedStatement for set membership (The IN operator) Daron Ryan <daron.ryan@gmail.com>
Re: PreparedStatement for set membership (The IN operator) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: PreparedStatement for set membership (The IN operator) Daron Ryan <daron.ryan@gmail.com>
Re: PreparedStatement for set membership (The IN operator) Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: PreparedStatement for set membership (The IN operator) Daron Ryan <daron.ryan@gmail.com>
PreparedStatement with ANY Daron Ryan <daron.ryan@gmail.com>
Re: PreparedStatement with ANY Daron Ryan <daron.ryan@gmail.com>
Re: PreparedStatement for set membership (The IN operator) Thomas Markus <t.markus@proventis.net>
  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
Дата:
От: Heikki Linnakangas
Дата:
FAQ