case / coalesce problem with strings

From: "Dino Dini" <dino(at)pod-1(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: case / coalesce problem with strings
Date: 2000-11-27 05:03:14
Message-ID: 000b01c0582f$59b33d80$c5d32304@pod1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Dino Dini 2000-11-27 05:10:10 Re: case / coalesce problem with strings WORKAROUND
Previous Message Tom Lane 2000-11-27 01:06:59 Re: Fails to add function from file with \i in psql