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