Index: doc/src/sgml/ref/select.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v retrieving revision 1.83 diff -c -c -r1.83 select.sgml *** doc/src/sgml/ref/select.sgml 8 Apr 2005 00:59:58 -0000 1.83 --- doc/src/sgml/ref/select.sgml 22 Apr 2005 04:15:06 -0000 *************** *** 830,840 **** ! FOR UPDATE may appear before ! LIMIT for compatibility with ! PostgreSQL versions before 7.3. It ! effectively executes after LIMIT, however, and ! so that is the recommended place to write it. --- 830,842 ---- ! It is possible for a SELECT command using both ! LIMIT and FOR UPDATE ! clauses to return fewer rows than specified by LIMIT. ! This is because LIMIT selects a number of rows, ! but might then block requesting a FOR UPDATE lock. ! Once the SELECT unblocks, the query qualifiation might not ! be met and the row not be returned by SELECT.