Thread: DELETE RETURNING

DELETE RETURNING

From
Daniel CAUNE
Date:
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