Re: text + text - Mailing list pgsql-general

From Tom Lane
Subject Re: text + text
Date
Msg-id 12095.1097245002@sss.pgh.pa.us
Whole thread Raw
In response to Re: text + text  (David Garamond <lists@zara.6.isreserved.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: when to use NULL and when to NOT NULL DEFAULT ''
Next
From: Michael Glaesemann
Date:
Subject: Re: when to use NULL and when to NOT NULL DEFAULT ''