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?
At 10:12 AM 8/15/2000, DalTech - CTE wrote:
That worked! Thanks!
The second part is why does postgresql not evaluate the function if one of the arguments is null?
That worked! Thanks!
The second part is why does postgresql not evaluate the function if one of the arguments is null?
- [SQL] Functions with Null Arguments? Thomas Swan
- Re: [SQL] Functions with Null Arguments? DalTech - CTE
- Re: [SQL] Functions with Null Arguments? Thomas Swan
- Re: [SQL] Functions with Null Arguments? Thomas Swan
- Re: [SQL] Functions with Null Arguments? Jesus Aneiros
