Re: factorial
From: <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 21 Jan 2002 18:30:15 +0000
Message-ID: <a2hnps$186g$2_at_sp15at20.hursley.ibm.com>
Date: Mon, 21 Jan 2002 18:30:15 +0000
Message-ID: <a2hnps$186g$2_at_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 - 19:30:15 CET