X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id D54079DD592
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  1 Dec 2005 11:23:17 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 35912-04-4
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  1 Dec 2005 11:23:10 -0400 (AST)
X-Greylist: delayed 01:00:01.803559 by SQLgrey-
Received: from ermsgsvr.werh.noaa.gov (ermsgsvr.werh.noaa.gov [198.206.32.50])
	by postgresql.org (Postfix) with ESMTP id 9616C9DD68F
	for <pgsql-sql@postgresql.org>; Thu,  1 Dec 2005 11:23:12 -0400 (AST)
Received: from [198.206.42.50] (hopper.wiln.noaa.gov [198.206.42.50])
	by ermsgsvr.werh.noaa.gov
	(iPlanet Messaging Server 5.2 HotFix 2.01 (built Aug 26 2004))
	with ESMTPSA id <0IQT00HPDPAJXG@ermsgsvr.werh.noaa.gov> for
	pgsql-sql@postgresql.org; Thu, 01 Dec 2005 09:23:09 -0500 (EST)
Date: Thu, 01 Dec 2005 09:23:06 -0500
From: Mark Fenbers <Mark.Fenbers@noaa.gov>
Subject: APPEND INTO?
To: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Message-id: <438F074A.3040004@noaa.gov>
Organization: DOC/NOAA/NWS/OHRFC
MIME-version: 1.0
Content-type: text/plain; charset=ISO-8859-1; format=flowed
Content-transfer-encoding: 7BIT
X-Accept-Language: en-us, en
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=1.166 required=5 tests=[SUBJ_ALL_CAPS=1.166]
X-Spam-Score: 1.166
X-Spam-Level: *
X-Archive-Number: 200512/1
X-Sequence-Number: 23543

I want to SELECT INTO mytable WHERE (criteria are met), except that I 
want to APPEND into an existing table the rows that are selected, 
instead of creating a new table (which SELECT INTO will do).  How can 
this be done?

(Is this what the "FOR UPDATE OF tablename" clause is for?)

Mark