Re: Update ordered

On 01/27/2014 06:36 AM, Andreas Joseph Krogh wrote:
> 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?

That would seem to depend on what get_next_project_number() does, the
contents of which are unknown.