Hello,

How can I increment consisting records like this:

Year  month   order         pos

2010  2                 1        null

2010  2                 1        null

2010  2                 1        null

2010  3                 2       null

Pos should be auto increment for all 2010 2 records, null to 1, the second record null to 2 til 4

Update table set pos = coalesce(pos,0)+1 where year = 2010 and month = 2 works not, all records have the pos=1 value

Thank you

Best regards

Olaf