postgresql a moj pokus o trigre

[Blasko Marek]

Kedze som nenasiel konferu o databazach a adresa ktoru mi niekto poslal
(databazy na linux.cz neodpoveda :( a ani sa nevratil mail) tak som tu zas.

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();
-------------------------------------

a po skusobnom update:

update dyndata set mslink='1001' where idmer=1;

ci

update dyndata set tdyn='a' where idmer=1;

to nieco dlho robi a potom co to prerusim tak spravi rollback.
-- 
   Blasko @vuje.sk
       k
Marek s
   e a                 (( \|/ ))
  r l                      |
 a Blasko                  |
Marek                      | 
            +------++     /_\
            |OM2AMB |----|/_\|
            +-------+   / \ / \