Postgres Pro
Downloads
Home   >   mailing lists

Re: [Q] Update from a table - Mailing list pgsql-general

From Tom Lane
Subject Re: [Q] Update from a table
Date
Msg-id 14196.1386252864@sss.pgh.pa.us
Whole thread Raw
In response to [Q] Update from a table  (Ladislav Lenart <lenartlad@volny.cz>)
Responses Re: [Q] Update from a table  (Ladislav Lenart <lenartlad@volny.cz>)
List pgsql-general
Tree view 
Ladislav Lenart <lenartlad@volny.cz> writes:
> What happens if I issue UPDATE SET FROM... but with incomplete/buggy WHERE
> condition and thus SEVERAL rows from the from_list match ONE row to update?

Any given row will be updated at most once.  However, the from_list row
it gets updated against will be unpredictable, depending on the
implementation of the join.

            regards, tom lane

pgsql-general by date:

Previous
From: Ladislav Lenart
Date:
Subject: [Q] Update from a table
Next
From: Ladislav Lenart
Date:
Subject: Re: [Q] Update from a table