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

Dear friends,   I have seen this is very drawback of our beloved postgres databases, postgres do not support sql 2003 standards,  I hope soon we can support this standards.   Thank you  

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

When  I use this syntax select * from TESTER; I got   TESTERIDPK  TESTER_NAME 10  TE 90     NAM 100 U   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,   RAN

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

    ANDI 33    TESTER 100    KKK   , so I want to make other primary key to