sequence number in a result - Mailing list pgsql-sql

Say I have the following SQL statement:

SELECT a, b, c FROM t1 ORDER BY a;

Is there a function or special system label I can use that would generate a sequence number in the returning result set?

Example:

SELECT a, b, c, SOMELABEL as order FROM t1 ORDER BY a;

Result:

a    b     c   order

---------------------

Aa  bb  cc  1

A1  bb  cc  2

A2  bb  cc  3

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu