Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 87AB2650292 for ; Mon, 8 Dec 2008 12:57:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 73546-10 for ; Mon, 8 Dec 2008 12:57:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mail.postgresql.org (Postfix) with ESMTP id 886616501F0 for ; Mon, 8 Dec 2008 12:57:24 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1L9jQ5-0007SL-Di for pgsql-admin@postgresql.org; Mon, 08 Dec 2008 16:57:17 +0000 Received: from gw-sf.securax.net ([89.253.129.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 08 Dec 2008 16:57:17 +0000 Received: from milen by gw-sf.securax.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 08 Dec 2008 16:57:17 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: Change in behavior of string concat operator Date: Mon, 08 Dec 2008 18:57:00 +0200 Lines: 37 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: gw-sf.securax.net User-Agent: Thunderbird 2.0.0.18 (Windows/20081105) In-Reply-To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200812/55 X-Sequence-Number: 30888 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