From: sidster <patrick@mail.boxsoft.com>
To: pgsql-sql@postgresql.org
Subject: is multiple insert possible with posgress?
Date: Mon, 15 May 2000 20:39:21 -0700
Message-ID: <20000515203921.B230@3eye.boxsoft.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: patrick@mail.boxsoft.com
Subject: Re: is multiple insert possible with posgress?
In-Reply-To: <20000515203921.B230@3eye.boxsoft.com>
References: <20000515203921.B230@3eye.boxsoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox