Skip site navigation (1) Skip section navigation (2)

Re: row numbering

From: Jay Guerette <jayguerette(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: row numbering
Date: 2005-02-28 05:45:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
OT: You have other database issues:

insert into WebLog values(586,31,"2005-02-28","<ip addr removed>")
Duplicate entry '2005-02-28' for key 2

On Sun, 27 Feb 2005 18:08:02 +0100, Karsten Hilbert
<Karsten(dot)Hilbert(at)gmx(dot)net> 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 @
> 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

In response to


pgsql-general by date

Next:From: Ragnar HafstaĆ°Date: 2005-02-28 06:33:25
Subject: Re: Referencing created tables fails with message that
Previous:From: Stephan SzaboDate: 2005-02-28 05:00:04
Subject: Re: Referencing created tables fails with message that

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group