Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 288E2476434
	for <pgsql-sql@postgresql.org>; Mon, 23 Dec 2002 11:35:13 -0500 (EST)
Received: from web13406.mail.yahoo.com (web13406.mail.yahoo.com
	[216.136.175.64])
	by postgresql.org (Postfix) with SMTP id 87377475925
	for <pgsql-sql@postgresql.org>; Mon, 23 Dec 2002 11:32:03 -0500 (EST)
Message-ID: <20021223163201.37261.qmail@web13406.mail.yahoo.com>
Received: from [24.73.195.91] by web13406.mail.yahoo.com via HTTP;
	Mon, 23 Dec 2002 08:32:01 PST
Date: Mon, 23 Dec 2002 08:32:01 -0800 (PST)
From: John Pauley <karstdiver@yahoo.com>
Subject: DB2 to Postgresql conversion help.
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/263
X-Sequence-Number: 10851

All,  Any suggestions on a Postgresql equivalent to
the following DB2 sql query:

SELECT * FROM (SELECT
ID,NAME,CITY,STATE,PROGRAM,CUST_NAME,CUST_ID,ROWNUMBER()
OVER (ORDER BY ID ASC) AS RN FROM
MERCHANT_BROWSER_VIEW WHERE CUST_ID = 'A51B8CA2' ) AS
RESULT WHERE RN BETWEEN 1 AND 20

TIA, Happy Holidays,
jp

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com