Subject | IBUDF - INVL function usage |
---|---|
Author | Martin D. Berezaga |
Post date | 2002-09-28T03:34:57Z |
I'm trying use INVL (from IBUDF) in an expression like:
SELECT INVL( MIN(INT_A), 0)
FROM A;
But I'm getting always 0, even if the SQL below doesn't return a null value:
SELECT MIN(INT_A)
FROM A;
When I use INVL( MIN(INT_A), 3), for example, I'm getting the correct
result: MIN(INT_A), if it's null.
Is this a bug?
Thanks in advance.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
SELECT INVL( MIN(INT_A), 0)
FROM A;
But I'm getting always 0, even if the SQL below doesn't return a null value:
SELECT MIN(INT_A)
FROM A;
When I use INVL( MIN(INT_A), 3), for example, I'm getting the correct
result: MIN(INT_A), if it's null.
Is this a bug?
Thanks in advance.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------