create trigger question

Andreas Joppich <andreas.joppich@t-mobil.de>

From: Andreas Joppich <andreas.joppich@T-Mobil.de>
To: pgsql-hackers@postgresql.org
Date: 1998-03-09T14:11:53Z
Lists: pgsql-hackers
Hi all,

at work I´m using RDB 6.2. I can create triggers with the following
command:

AFTER UPDATE OF
       SIM_ICCV_L,
       SIM_ICCNR_L,
       START_DATUM_D,
       STAT_SEIT_D,
       PREISKLASSE_T
ON ent_TEILNEHMER REFERENCING OLD AS update_old NEW AS update_new
    ( UPDATE ent_TEILNEHMER t
        SET t.update_l = update_old.update_l + 1,
           t.insert_datum_d = cast(current_timestamp as date)
        WHERE ent_TEILNEHMER.dbkey = t.dbkey )
FOR EACH ROW;

or:

AFTER INSERT ON ent_TEILNEHMER
        (UPDATE ent_TEILNEHMER t
           SET t.update_l = 1,
               t.insert_datum_d = cast(current_timestamp as date)
               WHERE ent_TEILNEHMER.dbkey = t.dbkey)
FOR EACH ROW;

With postgresql 6.2 or 6.3 I must use a user defined function to get the
same result. 

Will there be some enhancements to triggers to use the above syntax ? I
think,  RDB is more user friendly ( at least for trigger defintions)...

Bye
Andreas