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 по дате отправления