X-Original-To: pgsql-sql@postgresql.org
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id 345DD475AAC
	for <pgsql-sql@postgresql.org>; Tue, 18 Mar 2003 09:49:39 -0500 (EST)
Received: by news.hub.org (Postfix, from userid 8)
	id 167CC43A611; Tue, 18 Mar 2003 09:49:39 -0500 (EST)
From: "alexj" <alexj@freesurf.ch>
X-Newsgroups: comp.databases.postgresql.sql
Subject: trouble with query
Date: Tue, 18 Mar 2003 15:47:55 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Lines: 24
Message-ID: <3e7731a9$0$1051$5402220f@news.sunrise.ch>
To: pgsql-sql@postgresql.org
X-Archive-Number: 200303/467
X-Sequence-Number: 12506

Hi,

I'm looking how can I do to insert multiple values from a
complexe query.

What I want to do is something like that :

INSERT INTO est_planifie_jour (id,ref_activite,ref_ressource,ref_jour)
 (SELECT nextval('est_p_id_p') FROM est_planifie),
 (SELECT id_activite FROM activite WHERE
 nom = 'SGBD 02 cours théorique),
(SELECT ref_ressource FROM personne,groupe,fait_partie
 WHERE groupe.nom ='cycle 1b' AND
 fait_partie.ref_groupe = groupe.id_groupe AND
personne.id_personne = fait_partie.ref_personne),
(SELECT id_jour FROM jour WHERE jour.id_jour = 3)

Does anyone can advice me ?
--
/**
* Alexandre Jaquet
*/