[sqlite] Is there a way to return the row number? (NOT the rowid)

[Tony Papadimitriou]

Is there a function (or method), e.g., row(), to return the sequence number 
of the selected row?  This is not the same as ROWID.  row() should give a 
sequence number always starting from 1 up the to the number of rows returned 
by the view/select etc.

If not, then please add to the wish list.
TIA 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users