Re: [GENERAL] comparing two JSON objects in 9.3

2016-04-05 Thread yuri.ivane...@progforce.com
Wow. This is exactly what I'm looking for . The standard audit from here
https://wiki.postgresql.org/wiki/Audit_trigger is not good enough for me - I
want to audit only changed values and ignore all other ones.
Thank you Felix!

Regards,
Yuri.



--
View this message in context: 
http://postgresql.nabble.com/comparing-two-JSON-objects-in-9-3-tp5803617p5896917.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] comparing two JSON objects in 9.3

2016-04-06 Thread yuri.ivane...@progforce.com
There's also another way using hstore instead of json:
https://wiki.postgresql.org/wiki/Audit_trigger_91plus



--
View this message in context: 
http://postgresql.nabble.com/comparing-two-JSON-objects-in-9-3-tp5803617p5897128.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general