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.

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