idiom to move records? - Mailing list pgsql-sql

From Leslie Mikesell
Subject idiom to move records?
Date
Msg-id 199810260531.XAA14075@Mars.mcs.net
Whole thread Raw
Responses Re: [SQL] idiom to move records?
Re: [SQL] idiom to move records?
List pgsql-sql
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

pgsql-sql by date:

Previous
From: Michael Olivier
Date:
Subject: palloc failure: memory exhausted, but ulimit 'unlimited'
Next
From: Mike Meyer
Date:
Subject: Help on extensended attribute types?