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