[Info-ingres] Fw: One up unique number for an attribute - in SQL - does anyone know the trick of doing this?

[G Jones]

Does sort_order need to be saved in the table or just presented in the query results? If using Ingres 10.2 then row_number() could be useful. eg:

declare global temporary table session.x
(page_id integer, test_id integer)
on commit preserve rows with norecovery;

insert into session.x values
(1,1),(1,2),(1,3),(1,4),(1,5),
(1,4),(2,5),(2,1),(2,7),(3,10);

select page_id,test_id, row_number() over() sort_order
from session.x order by 1,2;