Thread

case / coalesce problem with strings

Dino Dini <dino@pod-1.com> — 2000-11-27T05:03:14Z

select 'hello ' || coalesce('there','there');
ERROR:  Function 'text(unknown)' does not exist
        Unable to identify a function that satisfies the given argument
types
        You may need to add explicit typecasts

It seems clear that the coalesce construction must return a string - so why
does this fail?

The followinfg works just fine:


-Dino