| 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: | Whole Thread | Raw Message | 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
| 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 '' |