11 Nov
2008
11 Nov
'08
6:39 p.m.
Hi,
I'm wonder what the proper :insert-into syntax would be to insert multiple rows simultaneously, like so:
"INSERT INTO my_table (col1, col2, col3) VALUES ('1', '2', '3'), ('4', '5', '6'), ...;"
As this tends to be much faster when inserting large data sets.
Also, the transaction functionality of postmodern doesn't seem to be well-documented. Is the only method of working with them to wrap calls in the with-transaction macro?
Thanks, Harry
--
Harry Bock
Software Developer, Package Maintainer
OSHEAN, Inc.
Email: harry@oshean.org
PGP Key ID: 546CC353