Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph
 [202.90.128.8])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f839XOf23220
	for <pgsql-sql@postgresql.org>; Mon, 3 Sep 2001 05:33:29 -0400 (EDT)
	(envelope-from joseph@asti.dost.gov.ph)
Received: from Askr (unknown [10.10.5.36])
	by kitana.asti.dost.gov.ph (Postfix) with SMTP id D507A2583E
	for <pgsql-sql@postgresql.org>; Mon,  3 Sep 2001 17:01:56 +0800 (PHT)
From: "Joseph Syjuco" <joseph@asti.dost.gov.ph>
To: <pgsql-sql@postgresql.org>
Subject: 
Date: Mon, 3 Sep 2001 17:02:36 +0800
Message-ID: <FHEOJMCOMLCBGLEMAKOGMENPCCAA.joseph@asti.dost.gov.ph>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Importance: Normal
X-Archive-Number: 200109/3
X-Sequence-Number: 4646

im new in postgresql (actually came from SQL Server) and i was trying a
script like this

insert into table1(field1,field2) values (select field1, field2 from table
2);

i dont know if this is possible (inserting a set of entries via resultset
from a select stmt in one command).  If anyone has any answers, or
workarounds pls do email me

Thanks