Benjamin Krajmalnik написа:
> Thanks.
>
> Then we have an inconsistency between this and the documentation for the || operator, where it is showing the abilty
toconcat numeric types without explicit casting.
>
> http://www.postgresql.org/docs/8.3/static/functions-string.html
On second reading of your post (and the documentation) we are both wrong
- the _string_ concatenation operator works when at least one of the
operands is a string.
>
>> -----Original Message-----
>> From: pgsql-admin-owner@postgresql.org
>> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Milen A. Radev
>> Sent: Saturday, December 06, 2008 12:49 PM
>> To: pgsql-admin@postgresql.org
>> Subject: Re: [ADMIN] Change in behavior of string concat operator
>>
>> Benjamin Krajmalnik написа:
>>> I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64.
>>> Running 8.3.5
>> [...]
>>> Select userid::varchar || accountno::varchar ||
>> requestdate::date as
>>> newcolumn from table At the very least, the documentation should be
>>> updated to reflect the new behavior, although I believe
>> this is a bug.
>>
>>
>> http://www.postgresql.org/docs/current/static/release-8-3.html
>> #AEN86272
[...]
--
Milen A. Radev