Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A42C41337B55 for ; Tue, 7 Dec 2010 17:14:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 47605-06 for ; Tue, 7 Dec 2010 21:14:37 +0000 (UTC) X-Greylist: delayed 00:07:20.786724 by SQLgrey-1.7.6 Received: from stan.prospectivdirect.com (mail.prospectiv.com [155.212.59.212]) by mail.postgresql.org (Postfix) with SMTP id D7E461337B4F for ; Tue, 7 Dec 2010 17:14:35 -0400 (AST) Received: (qmail 21559 invoked from network); 7 Dec 2010 21:07:13 -0000 Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87) by 0 with SMTP; 7 Dec 2010 21:07:13 -0000 Subject: concatenate question From: Tony Capobianco To: pgsql-sql@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Tue, 07 Dec 2010 16:07:13 -0500 Message-ID: <1291756033.16970.11.camel@tony1.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 (2.28.3-1.fc12) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/57 X-Sequence-Number: 34893 Here's my table: plsql_dw=# \d tmpsv_parent_master Table "staging.tmpsv_parent_master" Column | Type | Modifiers ----------------+-----------------------------+----------- memberid | numeric | addeddate | timestamp without time zone | sourceid | numeric | regcomplete | numeric(1,0) | optoutdate | date | bouncedate | date | websiteid | numeric | emailbounced | numeric(2,0) | emailok | numeric(2,0) | emailaddress | character varying(50) | srcwebsiteid | numeric | srcmemberid | numeric | sitetype | character varying | commissionpct | numeric | pricepermember | numeric | acceptrate | numeric(3,2) | mktgcenterid | numeric | label | character varying(32) | Why won't this work? plsql_dw=# select memberid || addeddate from tmpsv_parent_master limit 10; ERROR: operator does not exist: numeric || timestamp without time zone LINE 1: select memberid || addeddate from tmpsv_parent_master limit ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. Thanks.