Hi,
is there an elegant way to tell PG :
a) Hey PG, look here are e.g. 3 values A, B, c for tableX
b) please check if there is a row matching A and B as key in tableX
c) if such a row exists, execute an UPDATE on column c else INSERT a
new row.
Currently I have a trigger function that should store a value in tableX
whenever a certain column in tableY gets changed.
I do it with:
a) delete from tableX where key = ( A, B ) ( regardless if there is one )
b) insert into tableX
This seems not very efficient though it works.
Is there a better way?