Re: Functions with Null Arguments?

At 01:24 PM 8/15/2000, DalTech - CTE wrote:
>Known bug in some versions. I believe it was fixed in v7.x, though.
>
>Cheers....
>----- Original Message -----
>From: <mailto:tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)edu>Thomas Swan
>To: <mailto:CTE(at)Dal(dot)Ca>DalTech - CTE ; <mailto:tswan(at)olemiss(dot)edu>Thomas Swan
>Cc: <mailto:pgsql-sql(at)postgresql(dot)org>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)