Hello Robin,

giovedì, 18 giugno 98, you wrote:

RT> At 12:03 PM 6/17/98 +0000, 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 VALUES|              <--- I expected 100 here.
>>>  > (5 rows)

RT> SELECT name, NVL(salary, 0) + 100 AS dream FROM emp;

RT> NVL() takes two values: the column/variable, and the value to use if NULL.

RT> --
RT> Robin Thomas
RT> rthomas(at)azstarnet(dot)com
I don't think this work Robin, because there isn't such function on
PostgreSQL.
the only thing that I have is:

     function nvl(int4, int4) does not exist

Do you know how to implement it on PostgreSQL ?

Best regards,
 Jose'                            mailto:sferac(at)bo(dot)nettuno(dot)it

In response to

• Re: [GENERAL] COALESCE() or NVL() at 1998-06-18 20:44:48 from Robin Thomas

pgsql-hackers by date

Next:	From: Tom Lane	Date: 1998-07-08 13:56:17
	Subject: Re: [HACKERS] Trouble in paradise: cancel via postmaster ain't so cool
Previous:	From: Herouth Maoz	Date: 1998-07-08 12:27:15
	Subject: Re: [GENERAL] translate "bug"?

pgsql-general by date

Next:	From: Farzad FARID	Date: 1998-07-08 14:09:46
	Subject: How to rename a database?
Previous:	From: Bruce Tong	Date: 1998-07-08 13:08:02
	Subject: Re: [GENERAL] date and C