Benjamin Krajmalnik написа:
> Then we have an inconsistency between this and the documentation for the || operator, where it is showing the abilty to concat numeric types without explicit casting.
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(at)postgresql(dot)org
>> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Milen A. Radev
>> Sent: Saturday, December 06, 2008 12:49 PM
>> To: pgsql-admin(at)postgresql(dot)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.
Milen A. Radev
In response to
pgsql-admin by date
|Next:||From: Stephan Szabo||Date: 2008-12-08 16:57:52|
|Subject: Re: Change in behavior of string concat operator|
|Previous:||From: Scott Marlowe||Date: 2008-12-08 16:35:08|
|Subject: Re: Vacuum Problems|