Hi all. I want an UPDATE query to update my project's project_number in
chronological order (according to the project's "created"-column) and tried
this: with upd as(
select id from project order by created asc
) update project p set project_number = get_next_project_number() from upd
where upd.id = p.id; However, the olders project doesn't get the smalles
project_number. Any idea how to achive this? Thanks. --
Andreas Joseph Krogh <andreak(at)officenet(dot)no> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc