From: codeWarrior <GPatnude@adelphia.net>
To: pgsql-sql@postgresql.org
Subject: Re: inserting multiple rows with one statement
Date: Sun, 23 Feb 2003 11:26:17 -0800
Message-ID: <b3b71c$2m4$1@news.hub.org> (raw)
References: <e30679f9.0302211417.67629243@posting.google.com>
INSERT () SELECT ();
"Cali Hotstuff" <calihotstuff@hotmail.com> wrote in message
news:e30679f9.0302211417.67629243@posting.google.com...
> I know that this is easy to do in a programming language or with a
> script, but is there any way -- purely in SQL -- to insert multiple
> rows based on the results of a subquery.
>
> ie, if SubQuery yields rows {x,y,z}, I want to somehow insert these
> three different rows into MyTable on the same query.
>
> Thanks in advance,
> cali
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: GPatnude@adelphia.net
Subject: Re: inserting multiple rows with one statement
In-Reply-To: <b3b71c$2m4$1@news.hub.org>
* 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