On 05/31/2016 02:18 PM, car...@lpis.com wrote:
hello
this is my first question.
I am new in postgres and using plsql.
i am making this (bellow)
i want to insert one copy of one record into the log table but if there
is some change into the original recor to update into this record two
fields
Try this:
CREATE OR REPLACE FUNCTION lst_tot_mytable_LOG() RETURNS trigger
LANGUAGE plpgsql
AS $$
BEGIN
IF (TG_OP = 'UPDATE') THEN
INSERT INTO lst_tot_mytable_log SELECT 'U', now(), OLD.*;
IF OLD.Peticionario != NEW.Peticionario
or OLD.interlocclte != NEW.interloc
On Tue, May 31, 2016 at 4:18 PM, wrote:
> ERROR: el operador no existe: character varying == character varying
> LINE 1: SELECT OLD.Peticionario == NEW.Peticionario or OLD.interlocc...
Perhaps you want the = operator?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQ
