Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo
Date
Msg-id 1092754281.2627.28.camel@dicaprio.akademie1.de
Whole thread Raw
In response to Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo  (Jean-Luc Lachance <jllachan@sympatico.ca>)
Responses Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo
List pgsql-sql
Tree view 
В Втр, 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@bluetwanger.de>

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: multi column foreign key for implicitly unique columns
Next
From: Markus Bertheau
Date:
Subject: Re: multi column foreign key for implicitly unique columns