Received: from k3.core.aeccom.com (gate2.aeccom.com [195.211.178.194])
	by postgresql.org (Postfix) with ESMTP id 65E17475F93
	for <pgsql-sql@postgresql.org>; Wed, 10 Jul 2002 08:25:40 -0400 (EDT)
Received: from cayambe.core.aeccom.com (cayambe.core.aeccom.com
 [192.168.2.12])
	by k3.core.aeccom.com (8.11.6/8.11.6) with ESMTP id g6ACPgd30016;
	Wed, 10 Jul 2002 14:25:42 +0200
Received: (from lutzeb@localhost)
	by cayambe.core.aeccom.com (8.11.6/8.11.0) id g6ACPgs21145;
	Wed, 10 Jul 2002 14:25:42 +0200
From: Dirk Lutzebaeck <lutzeb@aeccom.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <15660.10182.92232.720222@cayambe.core.aeccom.com>
Date: Wed, 10 Jul 2002 14:25:42 +0200
To: pgsql-sql@postgresql.org
Subject: How to get total number of rows when using LIMIT/OFFSET?
X-Mailer: VM 7.00 under 21.4 (patch 6) "Common Lisp" XEmacs Lucid
X-Archive-Number: 200207/135
X-Sequence-Number: 8514


Hello,

when using LIMIT/OFFSET is it possible to get also the total number of rows
besides the actual number of rows of the select? It should be there
because the whole list is ordered anyhow. I'm using 7.2.1.

Thanks for help,

Dirk