> 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.
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 tha
