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