Re: [SQL] PLEASE help ME , HOW TO GENERATE PRIMARY Keys on the fly

[andi]

When  I use this syntax select * from TESTER; I got   TESTERIDPK  TESTER_NAME 10          TESSSS 90          NAMAAAA 100         UUUUU   In ms sql server 2005 I use this select rank() over(order by testeridpk ) as rank , * from tester; I get the result is like this,   RANK   TESTERIDPK       TESTER_NAME 1     10                TESSS 2     90                NAMAAA 3     100               UUUUUUUU     How in postgres sql I get the same result , please help me, because iam really frustating with this duty.   Thank you