Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 25A9D9FB30B
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 22 Oct 2006 01:22:01 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 71718-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 22 Oct 2006 01:21:43 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36])
	by postgresql.org (Postfix) with ESMTP id BE8749FB28E
	for <pgsql-sql@postgresql.org>; Sun, 22 Oct 2006 01:21:43 -0300 (ADT)
Received: from tedy ([70.82.131.58]) by VL-MO-MR001.ip.videotron.ca
	(Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005))
	with ESMTP id <0J7I00265S46DD10@VL-MO-MR001.ip.videotron.ca> for
	pgsql-sql@postgresql.org; Sun, 22 Oct 2006 00:21:42 -0400 (EDT)
Date: Sun, 22 Oct 2006 00:21:37 -0400
From: Daniel CAUNE <d.caune@free.fr>
Subject: DELETE RETURNING
To: pgsql-sql@postgresql.org
Message-id: <000001c6f591$90c01bd0$0b00a8c0@tedy>
MIME-version: 1.0
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-Mailer: Microsoft Office Outlook 11
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Thread-index: Acb1kZCSSC7USL1BTyuNRtQ3k76Umg==
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.406 tagged_above=0 required=5 tests=AWL,
	SPF_HELO_SOFTFAIL, SPF_SOFTFAIL, SUBJ_ALL_CAPS, UPPERCASE_25_50
X-Spam-Level: **
X-Archive-Number: 200610/196
X-Sequence-Number: 26585

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