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

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