From: | Mario Cassanelli <mcassan(at)speedy(dot)com(dot)ar> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Quien es INSERTED/DELETED en POSTGRESQL..????? -->>NEW/OLD..??? |
Date: | 2005-05-19 12:27:05 |
Message-ID: | 428C8619.9070600@speedy.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
En SQLSERVER, en los triggers puedo usar INSERTED, en POSTGRESQL es NEW
ahora si tengo que hacer un
UPDATE E
SET NIVEL=1
FROM EMPLEADOS E INNER JOIN INSERTED I
ON I.EMPID=E.EMPID
LEFT OUTER JOIN EMPLEADOS AS M
ON E.MGRID=M.EMPID
la funcion ya la tengo creada, ya cree el triggers, pero me esta tirando
error
les paso la funcion:
CREATE OR REPLACE FUNCTION TRG_EMP_INS() RETURNS trigger AS '
DECLARE
intNUMROWS INT;
BEGIN
intNUMROWS:=1;
UPDATE E
SET lvl=
CASE
WHEN E.mgrid IS NULL THEN 0
ELSE M.lvl+1
END,
JERARQUIA=
CASE
WHEN E.mgrid IS NULL THEN "."
ELSE M.jerarquia
END + CAST(E.empid AS VARCHAR(10)) + "."
FROM EMPLEADOS AS E INNER JOIN NEW AS I
ON I.empid = E.empid
LEFT OUTER JOIN EMPLEADOS AS M
ON E.mgrid = M.empid;
END;'
LANGUAGE 'plpgsql';
From | Date | Subject | |
---|---|---|---|
Next Message | Ing. Jhon Carrillo | 2005-05-19 12:43:30 | Re: Como instalar PL/pgsql |
Previous Message | David Prieto | 2005-05-19 12:00:59 | RE: ODBC contra OLEdb |