At 01:24 PM 8/15/2000, DalTech - CTE wrote:<br /><blockquote cite="cite" type="cite"><font size="2">Known bug in some
versions. I believe it was fixed in v7.x, though.</font><br /> <br /><font size="2">Cheers....</font><dl><dd>-----
OriginalMessage ----- <dd>From: <a href="mailto:tswan-lst@tangent.ics.olemiss.edu">Thomas Swan</a><dd>To: <a
href="mailto:CTE@Dal.Ca">DalTech- CTE</a> ; <a href="mailto:tswan@olemiss.edu">Thomas Swan</a><dd>Cc: <a
href="mailto:pgsql-sql@postgresql.org">Pgsql-sql</a><dd>Sent:Tuesday, August 15, 2000 1:43 PM <dd>Subject: Re: [SQL]
Functionswith Null Arguments?<br /><br /><dd>At 10:12 AM 8/15/2000, DalTech - CTE wrote:<blockquote cite="cite"
type="cite"><fontsize="2"> </font></blockquote><dd>I would try using COALESCE(<tt>list</tt>)<font size="2"> which will
returnthe first non-NULL in the list.</font></dl></blockquote><dl><dd>That worked! Thanks!<br /><br /><dd>The second
partis why does postgresql not evaluate the function if one of the arguments is null? </dl><br /> I'm using version
7.0.2(x86 Linux)