Re: Is relational theory irrelevant?
Date: Tue, 18 Nov 2003 16:42:06 -0500
Message-ID: <v-adnWRHbejRDyeiRVn-tw_at_golden.net>
"Serge Rielau" <srielau_at_ca.eye-bee-m.com> wrote in message
news:bpduip$3p2$1_at_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.
What about decile or quartile? Received on Tue Nov 18 2003 - 22:42:06 CET