Rod Taylor <rbt(at)zort(dot)on(dot)ca> writes:> I believe that the coalesce function can> get you out of this... Speaking of which, why isn't it called NVL()?
Because the SQL92 standard calls it coalesce.
regards, tom lane