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

Поиск
Список
Период
Сортировка
Искать
От
Markus Bertheau
Тема
SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo
Дата
Msg-id
1092740863.2627.17.camel@dicaprio.akademie1.de
Список
Дерево обсуждения
SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau <twanger@bluetwanger.de>
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 Markus Bertheau <twanger@bluetwanger.de>
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance <jllachan@sympatico.ca>
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance <jllachan@sympatico.ca>
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau <twanger@bluetwanger.de>
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III <bruno@wolff.to>
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 


В списке pgsql-sql по дате отправления
От: Dino Vliet
Дата:
Сообщение: only last records in subgroups
От: Achilleus Mantzios
Дата:
FAQ