Обсуждение: how control update rows

Поиск
Список
Период
Сортировка

how control update rows

От
"Sabin Coanda"
Дата:
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

TIA,
Sabin

Re: how control update rows

От
Pavel Stehule
Дата:
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
>