Re: Functions with Null Arguments? - Mailing list pgsql-sql

From Thomas Swan
Subject Re: Functions with Null Arguments?
Date
Msg-id 5.0.0.11.2.20000815114308.020f6e40@tangent.ics.olemiss.edu
Whole thread Raw
In response to Re: Functions with Null Arguments?  ("DalTech - CTE" <CTE@Dal.Ca>)
List pgsql-sql
At 10:12 AM 8/15/2000, DalTech - CTE wrote:<br /><blockquote cite="cite" type="cite"><font size="2">I would try using
</font>COALESCE(<tt>list</tt>)<fontsize="2"> which will return the first non-NULL in the list.</font></blockquote><br
/>That worked! Thanks!<br /><br /> The second part is why does postgresql not evaluate the function if one of the
argumentsis null?<br /> 

pgsql-sql by date:

Previous
From: Jesus Aneiros
Date:
Subject: RE: Use a rule or a transaction
Next
From: Stephan Szabo
Date:
Subject: Re: copy from