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

["andi" <andi(at)mobile-elab(dot)com>]

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