Re: Performance on inserts
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Matthew Kirkwood <matthew@hairy.beasts.org>, Jules Bean <jules@jellybean.co.uk>, pgsql-hackers@postgresql.org
Date: 2000-10-15T21:50:35Z
Lists: pgsql-hackers
> Matthew Kirkwood <matthew@hairy.beasts.org> writes: > > One of MySQL's little syntax abuses allows: > > INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..); > > Actually, that's perfectly standard SQL92, just an item we haven't > got round to supporting yet. (Until we do the fabled querytree > restructuring, it seems a lot harder than it is worth.) Added to TODO: INSERT INTO tab (col1, ..) VALUES (val1, ..), (val2, ..); -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026