Re: Is relational theory irrelevant?

From: Serge Rielau <srielau_at_ca.eye-bee-m.com>
Date: Tue, 18 Nov 2003 15:15:53 -0500
Message-ID: <bpduip$3p2$1@hanover.torolab.ibm.com>

Joe "Nuke Me Xemu" Foster wrote:

> "Paul Vernon" <paul.vernon_at_ukk.ibmm.comm> wrote in message <news:bpdpuh$1v88$1_at_gazette.almaden.ibm.com>...
>
>

>>Sniped in and bold added:
>>
>>    your *client program* opens the *cursor* and *iterates*

>
>
> Fine, then define sendmail() to take one or more relations
> as arguments and let /it/ do any iterating:
>
> sendmail(select address from harvestedlist, "MAKE MONEY FAST!!!")
>
> I suppose that if we can only push iteration down deep enough,
> it goes away entirely?
>

Ah, OK. Now what if I want to reuse the result of the sendmail function? Let's say to validate the email wasn't bounced (or least not malformed). What you have now is a sendmail relational operator :-)

A note to Mikito:
SQL was originally SEQUEL: Structured ENGLISH query language. And no, I'm not a native English speaker ... To fetch the LAST 5 ROWS ONLY one simply flips the ORDER BY :-) I have never seen a request to get the MIDDLE outside of TPC-C.

Cheers
Serge

-- 
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Received on Tue Nov 18 2003 - 14:15:53 CST