@janjan, this post discussed previously should also give you a clue of what @Xiphware is trying to explain.
In addition, you should also be able to find more discussions on the coalesce function here.
coalesce
