Re: Typo in online docs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Typo in online docs
Date
Msg-id 20100224141209.GE3790@alvh.no-ip.org
Whole thread Raw
In response to Typo in online docs  (strk <strk@keybit.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: FW: Unable to install PostgreSQL on Windows Server 2003 SP2
Next
From: Gokulakannan Somasundaram
Date:
Subject: Re: A thought on Index Organized Tables