Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 635976500E1 for ; Sat, 6 Dec 2008 14:16:43 -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 96402-02 for ; Sat, 6 Dec 2008 14:16:40 -0400 (AST) X-Greylist: delayed 00:12:11.005206 by SQLgrey-1.7.6 Received: from mail.illumen.com (unknown [64.207.29.137]) by mail.postgresql.org (Postfix) with ESMTP id 4010A6500B4 for ; Sat, 6 Dec 2008 14:16:40 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C957CD.14146F6E" Subject: Change in behavior of string concat operator Date: Sat, 6 Dec 2008 11:04:27 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Change in behavior of string concat operator Thread-Index: AclXzRP3A89g9v4oSq6BEkR3dW2/OA== From: "Benjamin Krajmalnik" To: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.101 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200812/34 X-Sequence-Number: 30867 This is a multi-part message in MIME format. ------_=_NextPart_001_01C957CD.14146F6E Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64. Running 8.3.5 =20 I have a query concatenating 3 columns to create a hash. userid is a numeric(38,0) field, accountno is an integer, and requestdate is a date. =20 Under 8.1, Select userid || accountno || requestdate::date as newcolumn from table executed ok. Under 8.3, it gives the following error: =20 operator does not exist: numeric || integer =20 Typecasting the first two columns to varchar resolved the problem. =20 Select userid::varchar || accountno::varchar || requestdate::date as newcolumn from table=20 At the very least, the documentation should be updated to reflect the new behavior, although I believe this is a bug. =20 ------_=_NextPart_001_01C957CD.14146F6E Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I just = migrated from=20 8.1 to 8.3, running on FreeBSD 7.0 amd64.
Running=20 8.3.5
 
I have = a query=20 concatenating 3 columns to create a hash.
userid = is a=20 numeric(38,0) field, accountno is an integer, and requestdate is a=20 date.
 
Under = 8.1, =20 Select userid || accountno || requestdate::date as newcolumn from table = executed=20 ok.
Under = 8.3, it gives=20 the following error:
 
operator does not=20 exist: numeric || integer
 
Typecasting the=20 first two columns to varchar resolved the problem.
 
Select = userid::varchar || accountno::varchar || requestdate::date as newcolumn = from=20 table
At the = very least,=20 the documentation should be updated to reflect the new behavior, = although I=20 believe this is a bug.
 
------_=_NextPart_001_01C957CD.14146F6E--