Re: text + text

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: text + text
Date: 2004-10-08 14:16:42
Message-ID: 12095.1097245002@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2004-10-08 14:37:06 Re: when to use NULL and when to NOT NULL DEFAULT ''
Previous Message David Garamond 2004-10-08 14:11:37 Re: when to use NULL and when to NOT NULL DEFAULT ''