Received: from cosmo.ktb.net (root@cosmo.ktb.net [198.175.228.45]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA10516 for ; Mon, 15 May 2000 23:39:14 -0400 (EDT) (envelope-from patrick@mail.boxsoft.com) Received: from cy02-14.ktb.net (cy02-14.ktb.net [198.175.228.174]) by cosmo.ktb.net (8.10.1/KTBNET-4.0) with ESMTP id e4G3bxN22221 for ; Mon, 15 May 2000 20:37:59 -0700 Received: (qmail 14961 invoked from network); 16 May 2000 03:38:59 -0000 Received: from unknown (HELO 3eye.boxsoft.com) (root@192.168.69.3) by 192.168.69.1 with SMTP; 16 May 2000 03:38:59 -0000 Received: (from patrick@localhost) by 3eye.boxsoft.com (8.9.3/8.9.3) id UAA10107 for pgsql-sql@postgresql.org; Mon, 15 May 2000 20:39:21 -0700 Date: Mon, 15 May 2000 20:39:21 -0700 From: sidster To: pgsql-sql@postgresql.org Subject: is multiple insert possible with posgress? Message-ID: <20000515203921.B230@3eye.boxsoft.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 1.0i X-Archive-Number: 200005/3 Greetings friends, I've started to look at postgreSQL for a potential rdbms platform to move our development to. However, i have found one slight short-coming thus far. I seems that multiple inserts are not supported by postgres: e.g., INSERT INTO test VALUES ( 'one', 1, 2, 3 ), ( 'two', 2, 3, 4 ), ( . . -- you get the idea . -- now imagine a hundred or so of these ), ( 'ten', 10, 11, 12 ); will generate the following error: ERROR: parser: parse error at or near "," Is this type of insert not supported at all? I did a search through the mailing lists (namely pgsql-sql and pgsql-general). Admittedly the search wasn't exhaustive but i was unable to 'hit' on any relevant topic. Could someone please clarify whether or not multiple-inserts are planned for a near-future release? Pointers to documentation and/or mailing-list discussions would be appreciated. tia, patrick -- Abstainer: a weak person who yields to the temptation of denying himself a pleasure. -- Ambrose Bierce