Re: update with from - Mailing list pgsql-general

From Sim Zacks
Subject Re: update with from
Date
Msg-id 4F1D6525.1050802@compulab.co.il
Whole thread Raw
In response to update with from  (Sim Zacks <sim@compulab.co.il>)
Responses Re: update with from  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
> 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


pgsql-general by date:

Previous
From: Hiroshi Saito
Date:
Subject: Re: PGbouncer for Windows 2008
Next
From: Stuart Bishop
Date:
Subject: Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?