Known bug in some versions. I believe it was fixed in v7.x, though.
Cheers....
- ----- Original Message -----
- From: Thomas Swan
- To: DalTech - CTE ; Thomas Swan
- Cc: Pgsql-sql
- Sent: Tuesday, August 15, 2000 1:43 PM
- Subject: Re: [SQL] Functions with Null Arguments?
- At 10:12 AM 8/15/2000, DalTech - CTE wrote:
- I would try using
COALESCE(list) which will return the first non-NULL in the list.- That worked! Thanks!
- The second part is why does postgresql not evaluate the function if one of the arguments is null?
I'm using version 7.0.2 (x86 Linux)
