OT: You have other database issues: http://www.gnumed.org/ <snip> error insert into WebLog values(586,31,"2005-02-28","<ip addr removed>") Duplicate entry '2005-02-28' for key 2 </snip> On Sun, 27 Feb 2005 18:08:02 +0100, Karsten Hilbert <Karsten.Hilbert@xxxxxxx> 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. > 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 > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
