Bug #35834 for DBD-Pg: Cannot mix placeholder styles ":foo" and "?"

On Tue May 13 06:29:18 2008, KES wrote: Show quoted text
Try this: $dbh->{pg_placeholder_dollaronly} = 1; $SQL = 'SELECT (ARRAY[1,2])[1:2], $1::int'; # note single quotes $dbh->selectall_arrayref($SQL); The pg_placeholder_dollaronly was designed for cases like this in which the query contains ? and : which are used as non-placeholders. While it's possible to improve DBD::Pg's internal parser to correctly read statements like the example above, there are more complex cases than the one you gave that would be very difficult to parse, so it's far easier for us (and safer for the user) to simply use pg_placeholder_dollaronly and stick to "dollarsign" placeholders.