Re: Is relational theory irrelevant?

"Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message news:bpe69u$10o4$2_at_gazette.almaden.ibm.com...
> "Bob Badour" <bbadour_at_golden.net> wrote in message
> news:ToednUdmpdK1Dyei4p2dnA_at_golden.net...
> > Sending an email is not information--it is an activity. The email is
> > information. The recipient is information. Sending is not information.
>
> Can you provide me with a definition by which I can separate things into
> information and activity classifications.

I think what Serge meant to say is

CREATE table EmailAddresses (

    address String,
    lastNotified Date,
)

CREATE TRIGGER send_email

    AFTER UPDATE ON EmailAddresses FOR EACH ROW begin

    if :new.LastNotified!=:old.LastNotified then

        sendEmail (:new.address);
    end;
end

update EmailAddresses
set LastNotified = SYSDATE
where <target criteria>
and LastNotified < SYSDATE - 1 -- notified no later than yesterday

I suggest that sendEmail function should return boolean value so that it were impossible to use it in queries. (Didn't SQL designers disable boolean datatype just for that occasion?-)

Again, where is the problem? Received on Tue Nov 18 2003 - 17:58:28 CST