On 05/15/2015 04:35 PM, Robert Haas wrote:
I guess JDBC has the same problem as Perl and JavaScript here: ?
signals a bind variable. The next question is, why isn't there some
escaping mechanism for that, like writing ?? or \? or something?
FTR, Perl's DBD::Pg lets you do this:
$dbh->{pg_placeholder_dollaronly} = 1; # disable ? placeholders
$sth = $dbh->prepare(q{SELECT * FROM mytable WHERE lseg1 ?# lseg2
AND name = $1});
$sth->execute('segname');
cheers
andrew
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
