DELETE RETURNING - Mailing list pgsql-hackers

From Markus Schaber
Subject DELETE RETURNING
Date
Msg-id 451793CD.5050506@logix-tt.com
Whole thread Raw
Responses Re: DELETE RETURNING  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-hackers
Hi,

I just read the docs about DELETE RETURNING in 8.2, and a small idea arised:

INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01'
RETURNING *;

Will this work as expected?

It might be a good example to put into the docs then.

If not, it may be worth the effort to make it work in 8.3.


Thanks,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: 8.3 Development Cycle
Next
From: Michael Meskes
Date:
Subject: Re: Windows build farm failures