> > 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. How, then, do I do it if I "need" the "row number" in a view ? Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match