Hello Robin,
giovedì, 18 giugno 98, you wrote:
RT> At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote:
>>> Jose' Soares Da Silva writes:
>>> > SELECT name,NVL(salary)+100 AS dream FROM emp;
>>> > name |dream
>>> > ---+-
>>> > Sam| 1300
>>> > Claire | 5100
>
At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote:
>> Jose' Soares Da Silva writes:
>> > SELECT name,NVL(salary)+100 AS dream FROM emp;
>> > name |dream
>> > ---+-
>> > Sam| 1300
>> > Claire | 5100
>> > Bill | 4300
>> > Ginger | 4900
>> > NULL V
I got sum(money attribute) to return 0.00 instead of NULL when there
are zero tuples in class, by redefining the sum() aggregate to set
initcond1 to 0.00. Perhaps you do something similar with your AVL().
-- Replace existing sum(money) to return $0.00
-- for zero instances
drop a
Hi all,
I'm looking for a function like COALESCE() or the Oracle NVL(),
to returns a ZERO value instead of a NULL value.
To have the result: NULL+1 = 1 instead of NULL+1 = NULL
Have PostgreSQL something like this ?
I tried to write it on C but I can't realize the beavior of NULLs,
I can't get tha
