X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by developer.postgresql.org (Postfix) with ESMTP id 63D0A923538
	for <pgsql-sql@postgresql.org>; Tue, 20 May 2003 05:16:02 -0400 (EDT)
Received: from developer.postgresql.org ([64.117.224.193])
	by localhost (developer.postgresql.org [64.117.224.193:10024])
	(amavisd-new) with ESMTP id 72552-10 for <pgsql-sql@postgresql.org>;
	Tue, 20 May 2003 05:15:41 -0400 (EDT)
Received: from hub.org (hub.org [64.117.224.146])
	by developer.postgresql.org (Postfix) with ESMTP id 021F99232BE
	for <pgsql-sql@postgresql.org>; Mon, 19 May 2003 22:15:16 -0400 (EDT)
Received: from hub.org (hub.org [64.117.224.146])
	by hub.org (Postfix) with ESMTP id A18B7184EFF1
	for <pgsql-sql@postgresql.org>; Mon, 19 May 2003 23:15:15 -0300 (ADT)
X-Received: from localhost ([unix socket])
	by hub.org (Cyrus v2.2.prealpha) with LMTP;
	Mon, 19 May 2003 02:23:53 -0300
X-Sieve: CMU Sieve 2.2
X-Received: by hub.org (Postfix, from userid 80)
	id DC5CD184FB8F; Mon, 19 May 2003 02:23:06 -0300 (ADT)
To: info@pgsql.com
Subject: Inquiry From Form [pgsql]
From: Rajendran <rajendran@davlin.co.in>
Message-Id: <20030519052306.DC5CD184FB8F@hub.org>
Date: Mon, 19 May 2003 02:23:06 -0300 (ADT)
X-Spam-Status: No, hits=0.0 required=5.0
	tests=none
	version=2.53
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.53 (1.174.2.15-2003-03-30-exp)
ReSent-Date: Mon, 19 May 2003 23:15:09 -0300 (ADT)
Resent-From: "Marc G. Fournier" <scrappy@hub.org>
Resent-To: pgsql-sql@postgresql.org
ReSent-Subject: Inquiry From Form [pgsql]
ReSent-Message-ID: <20030519231509.R46838@hub.org>
X-Virus-Scanned: by amavisd-new
X-Archive-Number: 200305/439
X-Sequence-Number: 13604

I need your help for getting particular records from the table in postgres.
How to use \'fetch\' keyword in postgres.
Can u please give me the syntax to retrieve the no of records in postgres?