Posts by Lucas Simões • 11 points

• 0

  votes

  2

  answers

  246

  views

  A: Postgres: How to compare json to create audit Trigger and display only differences

  I managed to solve the problem in a slightly different way that in my view was good for the result I wanted. CREATE OR REPLACE FUNCTION auditoria() RETURNS trigger AS $BODY$ DECLARE pCodigo integer;…

  postgresql trigger plpgsql

  answered 5 years, 9 months ago Lucas Simões 11

• 1

  votes

  2

  answers

  246

  views

  Q: Postgres: How to compare json to create audit Trigger and display only differences

  According to the structure below, I would like that when it was updated I could memorize only the differences. Example in the table produto I have the fields: prodcodigo = 1 proddescricao = 'FILTRO…

  postgresql trigger plpgsql

  asked 5 years, 9 months ago Lucas Simões 11