Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5EEA71337B4F for ; Tue, 7 Dec 2010 17:47:55 -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 57604-05 for ; Tue, 7 Dec 2010 21:47:48 +0000 (UTC) X-Greylist: from auto-whitelisted 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 CAA661337B7D for ; Tue, 7 Dec 2010 17:47:46 -0400 (AST) Received: (qmail 32426 invoked from network); 7 Dec 2010 21:47:46 -0000 Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87) by 0 with SMTP; 7 Dec 2010 21:47:46 -0000 Subject: Re: concatenate question From: Tony Capobianco To: pgsql-sql@postgresql.org In-Reply-To: References: <1291757825.16970.18.camel@tony1.localdomain> Content-Type: text/plain; charset="UTF-8" Date: Tue, 07 Dec 2010 16:47:46 -0500 Message-ID: <1291758466.16970.19.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/35 X-Sequence-Number: 34871 Ok, that worked. Why did I need to cast both as text though? plsql_dw=# select memberid::text||addeddate::text from tmpsv_parent_master limit 5; ?column? ------------------------------ 4005941032010-11-16 19:32:17 4005941952010-11-16 19:33:29 4005942842010-11-16 19:34:32 4005943492010-11-16 19:35:22 4005943662010-11-16 19:35:37 (5 rows) Thanks. On Tue, 2010-12-07 at 16:43 -0500, Peter Steinheuser wrote: > I think the HINT is what you need to look at. > > Cast both columns to text. > > On Tue, Dec 7, 2010 at 4:37 PM, Tony Capobianco > wrote: > 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. > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > > > > -- > Peter Steinheuser > psteinheuser@myyearbook.com