Re: factorial

From: <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 21 Jan 2002 18:30:15 +0000
Message-ID: <a2hnps$186g$2@sp15at20.hursley.ibm.com>

>> Table of integers is so important that I use table function for it.

>This is very proprietary and Standard SQL has nothing like it at all.
>To be honest, I have never see this before. God! It is so ....
>procedural!!

Maybe not, but I wouldn't say that tables or table functions that enumerate all values of a given type were 'procedural' in nature. It's only because (AFAIK) no DBMS supports such constructs natively, that something more procedural like the pipelined function mentioned earlier is needed. I could imagine that a good optimiser could work out the best traversal of the values of a type for a given query.

Regards.
Paul Vernon Received on Mon Jan 21 2002 - 12:30:15 CST