Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: Jean-Luc Lachance <jllachan(at)sympatico(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo
Date: 2004-08-17 14:51:21
Message-ID: 1092754281.2627.28.camel@dicaprio.akademie1.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

В Втр, 17.08.2004, в 16:26, Jean-Luc Lachance пишет:
> This query does not make sense to me.
> Why would you create an updatable subquery just to get the highest value?

To make sure that the highest value will be the highest value (or then
second-highest) after I commit the transaction. See my other answer.

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2004-08-17 14:57:38 Re: multi column foreign key for implicitly unique columns
Previous Message Tom Lane 2004-08-17 14:46:35 Re: multi column foreign key for implicitly unique columns