| 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: | Whole Thread | Raw Message | 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 |