Re: Prepared Statements - Mailing list pgsql-jdbc

From Darin Ohashi
Subject Re: Prepared Statements
Date
Msg-id F17255C2B596D3119A5600508B44FA68052EB86B@courier.maplesoft.on.ca
Whole thread Raw
In response to Prepared Statements  (Julien Le Goff <julien.legoff@laposte.net>)
Responses Re: Prepared Statements  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-jdbc
> > I would be surprised if there was not a document
> >somewhere that specified what is and is not valid to pass via a "?".
> >
> >
> If there is any, I've never heard of it...
>

Just as a data point, both postgresql's documentation for PREPARE

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-prepare.html

and IBM's

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/document.d2w
/report?fn=db2v7s0sqls0645.htm#HDRPREPH2

imply that only data can be passed in.  Its by implication because they discuss
the "data" having a "datatype".  I'm not sure this would make sense if you were
allowed to pass in strings containing SQL syntax.

Darin

pgsql-jdbc by date:

Previous
From: Felipe Schnack
Date:
Subject: Re: Prepared Statements
Next
From: Dmitry Tkach
Date:
Subject: Re: Prepared Statements