Received: from Kitten.mcs.com (Kitten.mcs.com [192.160.127.90]) by hub.org (8.9.1/8.9.1) with ESMTP id AAA25269 for ; Mon, 26 Oct 1998 00:31:12 -0500 (EST) (envelope-from les@Mars.mcs.net) Received: from Mars.mcs.net (les@Mars.mcs.net [192.160.127.85]) by Kitten.mcs.com (8.8.7/8.8.2) with ESMTP id XAA25311 for ; Sun, 25 Oct 1998 23:31:05 -0600 (CST) Received: (from les@localhost) by Mars.mcs.net (8.8.7/8.8.2) id XAA14075 for pgsql-sql@postgreSQL.org; Sun, 25 Oct 1998 23:31:05 -0600 (CST) From: Leslie Mikesell Message-Id: <199810260531.XAA14075@Mars.mcs.net> Subject: idiom to move records? To: pgsql-sql@postgreSQL.org Date: Sun, 25 Oct 1998 23:31:05 -0600 (CST) X-Mailer: ELM [version 2.4 PL24] Content-Type: text Is there a handy way to move a set of records to a different table in sql? I'd like to do this based on a WHERE clause and have it work atomically such that it will not lose new records added between the step that copies to the other table and deleting the copied records. Les Mikesell les@mcs.com