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