Received: from neouvielle.enseirb.fr (neouvielle.enseirb.fr [147.210.18.138]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CMGUx87321 for ; Mon, 12 Mar 2001 17:16:31 -0500 (EST) (envelope-from bayet@enseirb.fr) Received: from enseirb.fr (bayet.mds [172.16.8.139]) by neouvielle.enseirb.fr (8.9.3/8.9.3) with ESMTP id XAA24947 for ; Mon, 12 Mar 2001 23:14:29 +0100 (MET) Message-ID: <3AADBFD7.D462E190@enseirb.fr> Date: Mon, 12 Mar 2001 23:36:08 -0700 From: Richard Bayet X-Mailer: Mozilla 4.7 [fr] (Win98; I) X-Accept-Language: fr MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Use of the LIMIT clause ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/88 X-Sequence-Number: 936 I read on a website dedicated to MySQL, that the limit clause allows someone to restrict the result of a query to a certain domain. Exemple : "select id, title from movie order by id limit 3" -> only the (here, first) 3 lines of the table I did knew about this, but the author goes further about the "limit N,P", which allows someone to get only results between the Nth and Pth lines of the whole result... I tried this with psql, but couldn't get anything but parse errors. However, "\h select" does mention "LIMIT [count, all] {offset, START}" So, is it possible or not ? And what's the correct syntax ? Thanks