----- Original Message -----
From: <juerg.rietmann@pup.ch>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, March 13, 2001 12:45 PM
Subject: [SQL] copy a record from one table to another (archive)
> Hello there
>
> Is it possible to move a record from one table to another to do a archive
> with a simple command like move .... ?
>
begin; insert into archive_foo (select * from foo where foo_id=1); delete from foo where foo_id=1;
commit;
Is probably the closest you could get.
Alternatively, you could wrap the above up in a function and just go:
select do_archive_foo(1);
- Richard Huxton
