On 23 January 2012 14:48, Sim Zacks <s...@compulab.co.il> wrote: >> In my tests, if the joined rows are sorted it always updates with the >> first row. Does anyone have any other experiences, or should I be >> concerned that at some point it will behave differently? > > I checked my tests again. It always uses the last one, not the first one. > > Sim
I expect that your records get updated multiple times too. Perhaps you can use DISTINCT ON in your from-based UPDATE? -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
