From: Milen A. Radev <milen@radev.net>
To: pgsql-admin@postgresql.org
Subject: Re: Change in behavior of string concat operator
Date: Mon, 08 Dec 2008 18:57:00 +0200
Message-ID: <ghjjku$cdt$1@ger.gmane.org> (raw)
In-Reply-To: <F4E6A2751A2823418A21D4A160B689882B8ABD@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B689882B8AAF@fletch.stackdump.local>
<ghekvd$k54$1@ger.gmane.org>
<F4E6A2751A2823418A21D4A160B689882B8ABD@fletch.stackdump.local>
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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: milen@radev.net
Subject: Re: Change in behavior of string concat operator
In-Reply-To: <ghjjku$cdt$1@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox