Sequences and Views

Поиск
Список
Период
Сортировка
От JP Rosevear
Тема Sequences and Views
Дата
Msg-id 369CE5B1.B8698969@arcavia.com
обсуждение исходный текст
Список 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 по дате отправления: