Received: from cr168790-a.nmkt1.on.wave.home.com (IDENT:root@cr168790-a.nmkt1.on.wave.home.com [24.112.63.230]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA11302 for ; Wed, 13 Jan 1999 13:27:48 -0500 (EST) (envelope-from jproseve@arcavia.com) Received: from arcavia.com (jproseve@usjc064.uwaterloo.ca [129.97.122.80]) by cr168790-a.nmkt1.on.wave.home.com (8.8.7/8.8.7) with ESMTP id NAA04625 for ; Wed, 13 Jan 1999 13:27:46 -0500 Sender: jproseve@cr168790-a.nmkt1.on.wave.home.com Message-ID: <369CE5B1.B8698969@arcavia.com> Date: Wed, 13 Jan 1999 13:28:01 -0500 From: JP Rosevear Organization: Arcavia Software Ltd. X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Sequences and Views Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I'm trying to label rows when creating a view with the numbers 1...n, where n is the number of items in a view. Since views are requeryed when used in a select statement, using sequences breaks the 1 to n numbering. Under oracle the label was produced by the 'rownum' attribute. Suggestions? -JP