I am accessing AWS RedShift through DBI and
DBD::Pg module in Perl and I have some trouble with SQL bind variable. I call prepare with sql statement (
? in the place of variable) first and then I call execute with the variable array which needs to be mapped to
? but it doesn't work. It simply spits "syntax error".
My understanding is that this bind variable needs to be supported by the driver and the database itself so I am not sure whether it is a problem of the driver or RedShift but then I am not sure whether my understanding (bind variable support depends on the driver and underlying database) is correct. If someone could clarify, that would be great.