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_at_hanover.torolab.ibm.com>
>
>
> 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 :-)
Date: Tue, 18 Nov 2003 15:15:53 -0500
Message-ID: <bpduip$3p2$1_at_hanover.torolab.ibm.com>
Joe "Nuke Me Xemu" Foster wrote:
>
>
>>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 LabReceived on Tue Nov 18 2003 - 21:15:53 CET