Re: text + text

David Garamond <lists@zara.6.isreserved.com> writes:
> Peter Eisentraut wrote:
>>> What is "text + text" supposed to do right now?
>>
>> Nothing.

> Then are these bugs? (7.4.5 and 8.0.0beta1 give same results). Frankly,
> the current behaviour is quite strange to me.

CVS tip gives

regression=# select coalesce('1'+'0','NULL');
ERROR:  operator is not unique: "unknown" + "unknown"
HINT:  Could not choose a best candidate operator. You may need to add explicit type casts.
regression=#

See http://archives.postgresql.org/pgsql-hackers/2004-10/msg00041.php

            regards, tom lane