[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] address@hidden: Re: [GENERAL] row numbering]
From: |
Karsten Hilbert |
Subject: |
[Gnumed-devel] address@hidden: Re: [GENERAL] row numbering] |
Date: |
Mon, 28 Feb 2005 19:24:28 +0100 |
User-agent: |
Mutt/1.3.22.1i |
----- Forwarded message from Jay Guerette <address@hidden> -----
>
> 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
> <address@hidden> 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
----- End forwarded message -----
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gnumed-devel] address@hidden: Re: [GENERAL] row numbering],
Karsten Hilbert <=