| From: | Ian Pilcher <arequipeno(at)gmail(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | PreparedStatement syntax extensions? |
| Date: | 2011-08-26 15:51:50 |
| Message-ID: | j38fen$jcc$1@dough.gmane.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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(at)gmail(dot)com
"If you're going to shift my paradigm ... at least buy me dinner first."
========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maciek Sakrejda | 2011-08-26 16:49:12 | Re: PreparedStatement syntax extensions? |
| Previous Message | Stefan Reiser | 2011-08-26 14:19:26 | Exception when updating ResultSet |