postgresql a moj pokus o trigre

[Blasko Marek]

V linux cz som stim zacal a az neskor som prisiel jak sa dostat do tejto
konferi.

potrebujem previest trigre z ms SQL do postgresql

povodny triger znie:
CREATE TRIGGER trdyu ON dbo.dyndata 
FOR UPDATE 
AS
IF UPDATE (okam_hodn) OR UPDATE (okam_stav)
BEGIN

UPDATE  dyndata 
	SET casmer = GETDATE()	
	FROM dyndata dy, inserted ins
	WHERE dy.mslink = ins.mslink

END
GO

Podarilo sa my prihlasit plpgsql a tak som zacal prevadzat ten triger:
----------------------------------------------
CREATE FUNCTION getdate() RETURNS datetime
AS 'SELECT CURRENT_TIMESTAMP AS RESULT'
LANGUAGE 'sql';


CREATE FUNCTION uptime_dyn() returns opaque AS '
    BEGIN
    	UPDATE dyndata SET casmer = getdate()
    	WHERE mslink= new.mslink;
	return new;
    END; '
LANGUAGE 'plpgsql';

CREATE TRIGGER trdyu AFTER UPDATE ON dyndata FOR EACH ROW
EXECUTE PROCEDURE uptime_dyn();
------------------------------------------

ale je tam problem z rekurziou :( ktora je v originale osetrena:\

....IF UPDATE (okam_hodn) OR UPDATE (okam_stav)....


Pomozte my prosim

-- 
   Blasko @vuje.sk
       k
Marek s
   e a                 (( \|/ ))
  r l                      |
 a Blasko                  |
Marek                      | 
            +------++     /_\
            |OM2AMB |----|/_\|
            +-------+   / \ / \