Re: Is relational theory irrelevant?

"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote in message news:2rsub.15$wC5.76_at_news.oracle.com...
> "Serge Rielau" <srielau_at_ca.eye-bee-m.com> wrote in message
> news:bpc4ci$ogk$1_at_hanover.torolab.ibm.com...
> > Example:
> > SELECT * FROM (SELECT sendmail() FROM T) AS X WHERE c1 > 100;
> > How many emails shall be send? Correct (IMHO) would be: As many emails
> > as there are rows in T. In reality many DBMS will push the predicate
> > through to T for the sake of speed, and most customers evidently don't
> care.
>
> Doesn't sendmail() imply an argument -- email address?
>
> Next, what is the fact that you describe in your query? That's a set of
> folks that you want to target with your mail campain, right? Therefore,
your
> query fetches the result set of target emails, and your client program
opens
> the cursor and iterates through it and invokes sendmail at each step.

> Where is the problem?

Sniped in and bold added:

    your *client program* opens the *cursor* and *iterates*

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Tue Nov 18 2003 - 19:51:51 CET