case / coalesce problem with strings

Dino Dini <dino@pod-1.com>

From: "Dino Dini" <dino@pod-1.com>
To: <pgsql-bugs@postgresql.org>
Date: 2000-11-27T05:03:14Z
Lists: pgsql-bugs
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