Re: [rt.cpan.org #19604] ARRAY[] notation no longer supported in INSERT, missing bind parameter

"David Wheeler via RT" <[email protected]> Thu, 8 Jun 2006 15:40:59 -0400 (EDT)

Newsgroups	gmane.comp.db.postgresql.dbdpg
Message-ID	<[email protected]>

       Queue: DBD-Pg
 Ticket <URL: http://rt.cpan.org/Ticket/Display.html?id=19604 >

On Jun 8, 2006, at 12:31, Guest via RT wrote:

> $SQL = "INSERT INTO mytable(a,b) VALUES (ARRAY[?,?],?)";
> $sth = $dbh->prepare($SQL);
> $sth->bind_param(1,1,SQL_INTEGER);
> $sth->execute(1,2,3);

I see that the explicit bind_param is required. Why is that?

Best,

David