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

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