You might want to take at the triggers of DB2. Very thorough
implementation. DB2 even
has instead of triggers on Views.
http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/a...
Just my 2 cents.
John Wheeler
On 7/14/05, Fabian
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
------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users