[rt.cpan.org #19604] ARRAY[] notation no longer supported in INSERT, missing bind parameter
"Guest via RT" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <[email protected]> |
Queue: DBD-Pg
Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=19604 >
The problem does not seem to exist in newer versions, but I cannot tell
for sure without seeing the exact SQL you are using. However, this works
as expected:
$SQL = "INSERT INTO mytable(a,b) VALUES (ARRAY[?,?],?)";
$sth = $dbh->prepare($SQL);
$sth->bind_param(1,1,SQL_INTEGER);
$sth->execute(1,2,3);