PreparedStatement syntax extensions?

Поиск
Список
Период
Сортировка
Искать
От
Ian Pilcher
Тема
PreparedStatement syntax extensions?
Дата
Msg-id
j38fen$jcc$1@dough.gmane.org
Список
Дерево обсуждения
PreparedStatement syntax extensions? Ian Pilcher <arequipeno@gmail.com>
Re: PreparedStatement syntax extensions? Maciek Sakrejda <msakrejda@truviso.com>
Re: PreparedStatement syntax extensions? Ian Pilcher <arequipeno@gmail.com>
First off, I'm pretty much a noob with anything but very basic SQL and
JDBC, so apologies in advance if these are stupid questions ...

I am using the "WHERE foo = ANY (?)" syntax for my PreparedStatements to
avoid dynamically creating gigantic "IN (?, ?, ...)" statements.  After
much searching, I found it syntax in this thread:

  http://archives.postgresql.org/pgsql-jdbc/2011-04/msg00019.php

With all of my Google-fu, I have been unable to find any other mention
of this syntax anywhere else on the Interwebs, which brings me to
question #1:

Is this construct documented anywhere?

A follow-up post contains this PreparedStatement syntax:

  SELECT ?::int[]

Is this specifying a type for the PreparedStatement parameter?  If not,
what is it doing?

And again, is there any documentation of this syntax?

Thanks!

-- 
========================================================================
Ian Pilcher                                         arequipeno@gmail.com
"If you're going to shift my paradigm ... at least buy me dinner first."
========================================================================
В списке pgsql-jdbc по дате отправления
От: Stefan Reiser
Дата:
От: Maciek Sakrejda
Дата:
FAQ