Typo in online docs
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
strk wrote:
On this page:
http://www.postgresql.org/docs/8.4/interactive/explicit-locking.htmlThis chapter:
13.3.4. Advisory LocksThis 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; -- okLast statement seems bogus to me ...
Removed semicolon, thanks for the report
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support