[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);
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.