Postgres Pro
Downloads
Home   >   mailing lists

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

From Markus Bertheau
Subject SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo
Date
Msg-id 1092740863.2627.17.camel@dicaprio.akademie1.de
Whole thread Raw
Responses Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo  (Bruno Wolff III <bruno@wolff.to>)
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo  (Jean-Luc Lachance <jllachan@sympatico.ca>)
List pgsql-sql
Tree view 
Hi,

why is the following query not allowed:

SELECT MAX(position) FROM (SELECT position FROM classes WHERE name =
'foo' FOR UPDATE OF classes) AS foo

It's clear which rows should be locked here, I think.

Thanks

-- 
Markus Bertheau <twanger@bluetwanger.de>

pgsql-sql by date:

Previous
From: Dino Vliet
Date:
Subject: only last records in subgroups
Next
From: Achilleus Mantzios
Date:
Subject: Re: only last records in subgroups