Hello
2011/2/3 Sabin Coanda <s.coanda@deuromedia.ro>:
> Hi there,
>
> I'd like to control the rows which are updated. I found useful the option
> RETURNING in UPDATE syntaxt. Can I process the rows wich are returning there
> ?
>
> I think to something like that:
>
> SELECT *
> FROM (
> UPDATE "T" SET
> "C" = 1
> WHERE "ID" > 100
> RETURNING *
> ) x
>
It's not implemented yet. You can use a stored procedure or temp tables instead.
Regards
Pavel Stehule
> TIA,
> Sabin
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>