Aggregation Query


#1

Hi All, iam doing a aggregation query insert into another table. Now when the id is duplicate i set the value to overwrite with:

on conflict (id) do update set
val_average = val_average,
val_count = val_count,
val_max = val_max,
val_min = val_min,
val_sum = val_sum;

Hi All, iam doing a aggregation query insert into another table. Now when the id is duplicate i set the value to overwrite with:

     val_average = val_average,
     val_count = val_count,
     val_max = val_max,
     val_min = val_min,
     val_sum = val_sum;

The create date shows the row should be updated. but the actual value is not. Do you have an idea why this is?

or do i need to use?

     val_average = val_average,
     val_count = excluded.val_count,
     val_max = excluded.val_max,
     val_min = excluded.val_min,
     val_sum = excluded.val_sum;```