Thread: 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; -- okSELECT 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.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 ...

Removed semicolon, thanks for the report

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support