I must point out that syntax doesn't work in all DBMS. For PostgreSQL, you'll need something a bit more complex:

INSERT INTO
   table
SELECT val11, val12
UNION
SELECT val21, val22
UNION
SELECT val31, val32

etc.
[download]

I don't think this will be significantly faster for large collections of data than to just use DBI with a statement handle and placeholders (but YMMV).

--
Jeff Boes Database Engineer Nexcerpt, Inc.	vox 269.226.9550 ext 24 fax 269.349.9076  http://www.nexcerpt.com
...Nexcerpt...Connecting People With Expertise