Re^3: Perl DBI escape reserved word in Ingres database

in reply to Re^2: Perl DBI escape reserved word in Ingres database
in thread Perl DBI escape reserved word in Ingres database

It doesn't look like BOOLEAN is mentioned in DBD::Ingres so try

my $sql = "SELECT DISTINCT id FROM mytable WHERE open = CAST(? AS BOOL
+EAN)";
my $ref =  $dbh->selectall_arrayref($sql,undef,'true');
@id = map{ $_->[0] } @$ref;
die join (", ", @id), "\n";
[download]

poj

Comment on Re^3: Perl DBI escape reserved word in Ingres database Download Code

Replies are listed 'Best First'.
Re^4: Perl DBI escape reserved word in Ingres database by jtech (Sexton) on Feb 22, 2019 at 15:23 UTC
Whoops, it doesn't work, I did a wrong test previously, sorry my bad. Also, BOOLEAN(?) doesn't work either. btw Ingres doc is poor, IMHO it is a dead technology :/	[reply]

In Section Seekers of Perl Wisdom