> 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
If it's just one table with unique values that you can group by then you
should be able to adapt this:
test=> select * from blah2;
a
-----
AAAAA
BBBBB
aaaaa
bbbbb
(4 rows)
test=> select count(b1.oid), b1.a from blah2 b1, blah2 b2 where
b1.oid>=b2.oid group by b1.a;
count|a
-----+-----
1|AAAAA
2|BBBBB
3|aaaaa
4|bbbbb
(4 rows)
Hope this helps,
-DEJ