On 22/02/2011 5:18 PM, Vibhor Kumar wrote:
If you are using PG 8.4 then you can try something with row_number as
given below:
select id,stamp, row_number() over(order by stamp) from test;
Or
Create table test1 as select row_number() over(order by stamp) as id, stamp
from test;
Thanks& Regards,
Vibhor Kumar
I have not come across that that function before. I'll take a closer look.
Many thanks to all for the quick responses.
Howard.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
