Re: UPDATE ... RETURNING atomicity - Mailing list pgsql-general

From rihad
Subject Re: UPDATE ... RETURNING atomicity
Date
Msg-id 4BF90A1B.3010801@mail.ru
Whole thread Raw
In response to Re: UPDATE ... RETURNING atomicity  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: UPDATE ... RETURNING atomicity  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
On 05/23/2010 03:15 PM, Grzegorz Jaśkiewicz wrote:
> every single query in postrgresql runs as a transaction, on top of it,
> some are atomic, like when you use RETURNING statement. This is
> because postgresql doesn't actually have to select these rows as
> separate query.

Please note the cooperation of the UPDATE and the inner sub-SELECT
query, which was my point.

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: UPDATE ... RETURNING atomicity
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: UPDATE ... RETURNING atomicity