5 ms·
clever! hadn't thought of combining this with hstore.
by kmdupree 5y ago
clever! hadn't thought of combining this with hstore.
- 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.