Does RedShift Postgresql support Bind variable?

By : kee

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.

By : kee

This video can help you solving your question :)
By: admin