Thread: plz, Help!! HOW CAN I GET THE ROWNUM IN POSTGRES TABLE AS I DID WITH ORACLE!!

On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
At first, don't use all caps.

--
Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

On Fri, Nov 24, 2000 at 08:35:34AM +0300, some SMTP stream spewed forth:
> On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> > CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
> At first, don't use all caps.

Heh, I was waiting for something like that.

>
> --
> Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga",
> Sochi, Russia
> http://www.brainbench.com/transcript.jsp?pid=304744

On Fri, Nov 24, 2000 at 08:35:34AM +0300, Igor' Robul' wrote:
> On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM I TO
> > CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN POSTGRESQL!!
> At first, don't use all caps.
And then, take any book about relation DBMS and read, that "row number"
is not applicable for relations, because in general two
SELECT * FROM rel;
may return rows in different order. And there no other way get records
from relation except SELECT :-)
So, if your algorithm needs "row numbers" redesign it. Or use
MS-Access or FoxPro.

--
Igor' Robul', Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

List z dnia:  Pi? 24. Listopad 2000 05:51,  :
> On Fri, Nov 24, 2000 at 08:35:34AM +0300, some SMTP stream spewed forth:
> > On Mon, Nov 20, 2000 at 12:44:20PM +0800, BaiJie wrote:
> > > I KNOW THERE IS A OID FIELD ,BUT IT 'S WIRED , NOT A INTEGER INDEX FROM
> > > I TO CURRENT ROW NUMBER!! HOW CAN I GET THE TRUE ROW NUMBER IN
> > > POSTGRESQL!!
> >
> > At first, don't use all caps.
>
> Heh, I was waiting for something like that.
>
I was resolved this problem with my own int field (or whatever You want)
(if it is ok for You) and
then defined table like this:

create sequence test_seq;
create table test (
...
data
...
test id int4 default nextval('test_seq')
};

create index on that field

reason:
problem with copying data with relations to other databases

> > --
> > Igor' Robul', Unix System Administrator & Programmer @ sanatorium
> > "Raduga", Sochi, Russia
> > http://www.brainbench.com/transcript.jsp?pid=304744