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