| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1065.1 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Wed Mar 12 1997 14:14 | 3 |
| CDD doesn't support functions calls.
Ian
|
| 1065.2 | thank you | M5::JAKUHN | jakuhn@us.oracle.com | Wed Mar 12 1997 15:33 | 1 |
| *thanks* again Ian.
|
| 1065.3 | will ex functions be supported ? | M5::JAKUHN | jakuhn@us.oracle.com | Mon Mar 17 1997 16:58 | 14 |
| Does any one have a "rough guess" as to when/if CDD will ever support
Rdb's external functions? I think it is perfectly reasonable for the
customer to use an external function and expect CDD to support it.
The reason he tried to use an external function is that he need to
do an "integer" divide - in other words, throwing away the
fraction part. I don't think a "computed by" column can do that
kind of divide (I'm trying to think of a workaround), will he just
have to write code to do that?
thanks.
jay
|
| 1065.4 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Mon Mar 17 1997 19:10 | 24 |
| Yes CDD should support BLR$K_FUNCTION. However, I doubt that resources exist
to make this happen soon. Please send product requirements to Shirley Anne
Stern.
However, this might be acceptable..
SQL> create table T (a real,
cont> b computed by cast(cast(a as bigint(1)) as varchar(20)),
cont> c computed by cast(
cont> substring(b from 1
cont> for position('.' in b))
cont> as bigint));
SQL> insert into t (a) value (10.3);
1 row inserted
SQL> insert into t (a) value (11.7);
1 row inserted
SQL> select * from t
cont> ;
A B C
1.0300000E+01 10.3 10
1.1700000E+01 11.7 11
2 rows selected
Ian
|
| 1065.5 | thanks...again | M5::JAKUHN | jakuhn@us.oracle.com | Mon Mar 17 1997 19:53 | 6 |
| /Yes CDD should support BLR$K_FUNCTION. However, I doubt that resources
/exist
And I understand that of course. Thank you for the workaround Ian.
jay
|
| 1065.6 | | NOVA::SMITHI | Don't understate or underestimate Rdb! | Mon Mar 17 1997 20:00 | 7 |
| To explain further, adding support for functions is a complex task. It
requires that CDD know about the parameters (e.g. number and data type) as
well as the functions themselves. Further, a SQL function my live in a
module, so this implies some support of modules too. Such a large task is not
currently seen as a priority right now.
Ian
|
| 1065.7 | | M5::LWILCOX | How about Fireworks? | Mon Apr 07 1997 11:51 | 8 |
| <<< Note 1065.6 by NOVA::SMITHI "Don't understate or underestimate Rdb!" >>>
>> Such a large task is not currently seen as a priority right now.
Jay, maybe a career path? No, wait, we don't want you to leave support!!
:-).
|