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
