Sequences and Views - Mailing list pgsql-sql

From JP Rosevear
Subject Sequences and Views
Date
Msg-id 369CE5B1.B8698969@arcavia.com
Whole thread Raw
List pgsql-sql
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




pgsql-sql by date:

Previous
From: Patricia Rodriguez-Tome
Date:
Subject: Problem with simple select, RestrictionClauseSelectivity ERROR
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR