If you insert the results of your query into a table with a serial column, the serial column will do what you want.. On Sat, 2005-02-26 at 01:10 +0100, Peter Eisentraut wrote: > josue wrote: > > is there a way return a column with the row number automatically > > generated according the way the rows were processed by the query. > > No, but you can easily keep a counter in the client. > -- Mike Harding <mvh@xxxxxxxxxxxxx> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
