Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2454C475A1E for ; Tue, 5 Nov 2002 23:47:56 -0500 (EST) Received: from mail.av-navi.co.jp (mail.av-navi.co.jp [202.229.69.22]) by postgresql.org (Postfix) with SMTP id E3B4D4759F2 for ; Tue, 5 Nov 2002 23:47:54 -0500 (EST) Received: (qmail 20962 invoked from network); 6 Nov 2002 13:47:48 +0900 Received: from unknown (HELO netscape.net) (61.119.142.233) by mail.av-navi.co.jp with SMTP; 6 Nov 2002 13:47:48 +0900 Message-ID: <3DC89D1B.2010208@netscape.net> Date: Wed, 06 Nov 2002 13:39:55 +0900 From: Jean-Christian Imbeault Reply-To: jc@mega-bucks.co.jp User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en, ja MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Documentation bug report for LIMIT Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/6 X-Sequence-Number: 1530 In http://www6.jp.postgresql.org/users-lounge/docs/7.2/postgres/queries-limit.html it is stated that the syntax is: SELECT select_list FROM table_expression [LIMIT { number | ALL }] [OFFSET number] This following query is valid even though the syntax is wrong: select id from members order by id limit 5, 6 If this "alternative" syntax is acceptable could you add this alternative syntax to the docs? Else, the parser needs to throw an error? SELECT select_list FROM table_expression [LIMIT { number | ALL }] [, [OFFSET] number]