Dear Fabian, Thank you for your quick response. For now I mainly want to see if it is possible to (1) For each newly inserted tuple in a certain relation, automatically add (some) other tuple(s) to other relations based on this insert. (2) After each elapse of a certain time-interval remove (some) tuple(s) from (some) relation(s). Regards, Arthur On Thu, 2005-07-14 at 18:14, Fabian wrote:
Currently there are no triggers in MonetDB/SQL.
Niels knows if and when they will appear. What is it exactly that you want to achieve? "ON DELETE CASCADE" constructs, or more complicated "ON UPDATE EXECUTE compute_aggr()" like things?
Regards, Fabian
Arthur van Bunningen wrote:
Dear all,
First my compliments with this piece of useful and implemented research. Second I was wondering if there is a possibility to have so-called "triggers" in MonetDB such as in for example PostgreSQL [1] or if there are other ways to use MonetDB as an "active database".
If anyone has experiences in this field or can point me to the right place to look for this experience I would be very thankful.
Kind regards,
Arthur van Bunningen