Skip site navigation (1) Skip section navigation (2)

Re: Change in behavior of string concat operator

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Change in behavior of string concat operator
Date: 2008-12-08 16:57:00
Message-ID: ghjjku$cdt$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-admin
Benjamin Krajmalnik написа:
> Thanks.
> 
> 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.
> 
> 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(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.
>>
>>
>> http://www.postgresql.org/docs/current/static/release-8-3.html
>> #AEN86272
[...]


-- 
Milen A. Radev


In response to

pgsql-admin by date

Next:From: Stephan SzaboDate: 2008-12-08 16:57:52
Subject: Re: Change in behavior of string concat operator
Previous:From: Scott MarloweDate: 2008-12-08 16:35:08
Subject: Re: Vacuum Problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group