Re: Problems with question marks in operators (JDBC, ECPG, ...)

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