Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199406151427.HAA17277@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Wed, 15 Jun 1994 13:21:14 +0200 (MET DST)
From: ejonge@tpd.TNO.NL (Eric de Jonge)
Subject: new type & rule ?!
To: postgres@postgres.Berkeley.EDU (post list)
Cc: ejonge@tpd.TNO.NL (Eric de Jonge)
Message-id: <9406151121.AA05432@tpdusv.tpd.tno.nl>
Content-type: text
Content-transfer-encoding: 7BIT
Content-Length: 1051
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 15 Jun 94 07:27:07 -0700
Resent-XMts: smtp

I've defined :
- new data type IMAGEOBJ
- operator '=' to test if IMAGEOBJ = text

Example:

create imclass(field=IMAGEOBJ)
create teclass(field=text)

contents:

IMCLASS:
---------------
| field       |
---------------
| db_600629   |
---------------
| db_600636   |
---------------
| db_600643   |
---------------

TECLASS:
---------------
| field       |
---------------
| db_600629   |
---------------
| db_600636   |
---------------
| db_600643   |
---------------


AND NOW: define rule cascades is on delete to imclass 
         do delete teclass where current.field = teclass.field

So, on delete of an instance in imclass, the instance which's equal is also
removed.

COMMAND: delete imclass where imclass.field = "db_600643"

RESULT: remove the last instance of imclass and teclass

REALITY: ALL the instances of teclass were REMOVED!!


Conclusion : define a rule for built-in data types with CURRENT works;
          => define a rule for new data types with CURRENT not?!

Is this right?
-- 
_/ Eric de Jonge
_/ Email: ejonge@tpd.tno.nl 

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================