PostgreSQL: Enumerate SQL query result -

consider following sql query , response:

create temporary table dreams (name text, type text); insert dreams values ('monkey', 'nice'); insert dreams values ('snake', 'not nice'); insert dreams values ('donkey', 'nice'); insert dreams values ('bird', 'nice');  select name dreams type='nice' order name;   name --------  bird  donkey  monkey (3 rows) 

i enumerate results order of appearance, regardless of existing ids, convenience. expected result should a-la:

select <magic_enumeration>, name dreams type='nice' order name;   magic_enumeration |  name -------------------+--------  1                 | bird  2                 | donkey  3                 | monkey (3 rows)     

any ideas how enumerate query result order of appearance?

try using row_number, windowing function

select row_number() on (order name) sid, <-- magic enumeration!        name    dreams    type='nice'    order name;