3 ms·
``` , SUBSTRING(TG_OP, 1, 1) -- this gets you I,D,U, or T for truncate , HSTORE(oldData.*) - HSTORE(newData.*) , HSTORE(newData.*) - HSTORE(oldData.*)
by netcraft 5y ago
```
, SUBSTRING(TG_OP, 1, 1) -- this gets you I,D,U, or T for truncate
, HSTORE(oldData.*) - HSTORE(newData.*)
, HSTORE(newData.*) - HSTORE(oldData.*)
```
this is basically what we do, getting the old and new of only what changed.