Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoiding a deadlock - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: Avoiding a deadlock
Date
Msg-id CA+6hpa=hWt50u-yz4Pwukk5O57M8gfYhYqnn12R9gfwbdAZ9zQ@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding a deadlock  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: Avoiding a deadlock
List pgsql-general
Tree view
> Out of curiosity: any reason the ORDER BY should be in the subquery? It seems like it ought to be in the UPDATE (if that's allowed).

Hmm, it's not allowed. :-) It's still surprising that you can guarantee the order of a multi-row UPDATE by ordering a subquery.

Paul

--
_________________________________
Pulchritudo splendor veritatis.

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: How to append an element to a row inside a 2-dim. array?
Next
From: Steve Erickson
Date:
Subject: Upgrading postgresql-8.4