Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8C958633B55 for ; Tue, 15 Jun 2010 16:43:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 90785-05 for ; Tue, 15 Jun 2010 19:42:58 +0000 (UTC) X-Greylist: whitelisted by SQLgrey-1.7.6 Received: from smtp6-g21.free.fr (smtp6-g21.free.fr [212.27.42.6]) by mail.postgresql.org (Postfix) with ESMTP id 9F17C633A33 for ; Tue, 15 Jun 2010 16:42:58 -0300 (ADT) Received: from toto.localnet (gev44-1-78-228-108-65.fbx.proxad.net [78.228.108.65]) by smtp6-g21.free.fr (Postfix) with ESMTP id 82058E08167 for ; Tue, 15 Jun 2010 21:42:53 +0200 (CEST) From: Florence Cousin To: pgsql-docs@postgresql.org Subject: For update clause Date: Tue, 15 Jun 2010 21:42:51 +0200 User-Agent: KMail/1.13.2 (Linux/2.6.33-ARCH; KDE/4.4.2; x86_64; ; ) MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Message-Id: <201006152142.52200.cousinflo@free.fr> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/33 X-Sequence-Number: 5601 Hi, I am one of the french translators of the documentation. I am translating the reference page of SELECT, but I fail to understand this sentence about the FOR UPDATE clause ( http://www.postgresql.org/docs/9.0/static/sql- select.html#SQL-FOR-UPDATE-SHARE ) --------------- In addition, rows that satisfied the query conditions as of the query snapshot will be locked, although they will not be returned if they have since been updated to not satisfy the query conditions. ------------------ Could anyone please explain it to me, so that I can translate it properly? A word for word translation has really no meaning. Florence