Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group