Re: Avoiding a deadlock

From: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Avoiding a deadlock
Date: 2013-03-11 15:52:49
Message-ID: CA+6hpa=hWt50u-yz4Pwukk5O57M8gfYhYqnn12R9gfwbdAZ9zQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Erickson 2013-03-11 15:57:05 Upgrading postgresql-8.4
Previous Message Stefan Keller 2013-03-11 15:51:58 How to append an element to a row inside a 2-dim. array?