Re: Functions with Null Arguments?

From: Thomas Swan <tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)edu>
To: "DalTech - CTE" <CTE(at)Dal(dot)Ca>, "Thomas Swan" <tswan(at)olemiss(dot)edu>
Cc: "Pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Functions with Null Arguments?
Date: 2000-08-15 16:43:51
Message-ID: 5.0.0.11.2.20000815114308.020f6e40@tangent.ics.olemiss.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-08-15 17:06:26 PL/pgSQL
Previous Message Adam Lang 2000-08-15 16:38:15 Re: copy from