On this page:
http://www.postgresql.org/docs/8.4/interactive/explicit-locking.html
This chapter:
13.3.4. Advisory Locks
This example:
SELECT pg_advisory_lock(id) FROM foo WHERE id = 12345; -- ok
SELECT pg_advisory_lock(id) FROM foo WHERE id > 12345 LIMIT 100; -- danger!
SELECT pg_advisory_lock(q.id) FROM
(
SELECT id FROM foo WHERE id > 12345 LIMIT 100;
) q; -- ok
Last statement seems bogus to me ...
--strk;
() Free GIS & Flash consultant/developer
/\ http://foo.keybit.net/~strk/services.html