Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 25B096501F3 for ; Mon, 8 Dec 2008 12:28:34 -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 69742-06 for ; Mon, 8 Dec 2008 12:28:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.illumen.com (unknown [64.207.29.137]) by mail.postgresql.org (Postfix) with ESMTP id 242136501D0 for ; Mon, 8 Dec 2008 12:28:24 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Subject: Re: Change in behavior of string concat operator Date: Mon, 8 Dec 2008 09:28:21 -0700 Message-ID: In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Change in behavior of string concat operator Thread-Index: AclX28nCba4Ehj+7RVCZCWMsVknf6wBdee6A References: From: "Benjamin Krajmalnik" To: "Milen A. Radev" , X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200812/52 X-Sequence-Number: 30885 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 =20 > -----Original Message----- > From: pgsql-admin-owner@postgresql.org=20 > [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 >=20 > Benjamin Krajmalnik =CE=C1=D0=C9=D3=C1: > > I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64. > > Running 8.3.5 > [...] > > Select userid::varchar || accountno::varchar ||=20 > requestdate::date as=20 > > newcolumn from table At the very least, the documentation should be=20 > > updated to reflect the new behavior, although I believe=20 > this is a bug. >=20 >=20 > http://www.postgresql.org/docs/current/static/release-8-3.html > #AEN86272 >=20 >=20 >=20 > --=20 > Milen A. Radev >=20 >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >=20