Skip site navigation (1) Skip section navigation (2)

Re: INS/UPD/DEL RETURNING for 8.2

From: "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com>
To: neilc(at)samurai(dot)com, jonah(dot)harris(at)gmail(dot)com
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: INS/UPD/DEL RETURNING for 8.2
Date: 2006-03-05 08:25:49
Message-ID: BAY20-F4F89076E252EDFEB05EF6F9E80@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-patches
>
>I wonder if we should try to consistently treat an INSERT/UPDATE/DELETE
>with a RETURNING clause like a SELECT with an equivalent target list.
>For example, should it be possible to write:
>
>FOR x in DELETE FROM t1 WHERE ... RETURNING t1.x LOOP
>     ...
>END LOOP;
>
>Or open a cursor for a data-modifying statement with a RETURNING clause,
>etc.
>
>-Neil

good idea
Pavel

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/


In response to

pgsql-patches by date

Next:From: Andrew DunstanDate: 2006-03-05 16:45:58
Subject: Re: implement prepared queries in plperl
Previous:From: Bruce MomjianDate: 2006-03-05 05:31:54
Subject: Re: Fix for /dev/tty on Win32

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group