Hi,
I have read in the future PostgreSQL 8.2 release note
(http://developer.postgresql.org/pgdocs/postgres/release-8-2.html) that
DELETE RETURNING will be supported. Tom, could please confirm that the
following PL/PGSQL statements will work on PostgreSQL 8.2?
INSERT INTO a(x, y) DELETE FROM b RETURNING x, current_timestamp;
IF NOT FOUND THEN -- No data were deleted actually END IF;
Thanks,
--
Daniel