On 01/27/2014 07:01 AM, Andreas Joseph Krogh wrote:
> På mandag 27. januar 2014 kl. 15:56:12, skrev Adrian Klaver
> <adrian.klaver@gmail.com <mailto:adrian.klaver@gmail.com>>:
>
> 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.
>
> get_next_project_number() gets the next project-number based on some
> custom logic.
> What would be the best way to update all project's project-number having
> the oldes project get the first number returned by
> get_next_project_number() etc.?
How are you sure it is not, have you tried something like below to test?:
with upd as(
select id from project order by created asc
) select p.id, p.create from project_number where upd.id = p.id;
