Sequences and Views

From: JP Rosevear <jproseve(at)arcavia(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Sequences and Views
Date: 1999-01-13 18:28:01
Message-ID: 369CE5B1.B8698969@arcavia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-01-13 18:51:54 Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
Previous Message Patricia Rodriguez-Tome 1999-01-13 17:34:41 Problem with simple select, RestrictionClauseSelectivity ERROR