Re: Functions with Null Arguments?
| От | Thomas Swan |
|---|---|
| Тема | Re: Functions with Null Arguments? |
| Дата | |
| Msg-id | 5.0.0.11.2.20000815132808.01ef3c78@tangent.ics.olemiss.edu обсуждение исходный текст |
| Ответ на | Functions with Null Arguments? (Thomas Swan <tswan@olemiss.edu>) |
| Список | pgsql-sql |
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)
В списке pgsql-sql по дате отправления: