concatenate question

From: Tony Capobianco <tcapobianco(at)prospectiv(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: concatenate question
Date: 2010-12-07 21:07:13
Message-ID: 1291756033.16970.11.camel@tony1.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Capobianco 2010-12-07 21:37:05 concatenate question
Previous Message bricklen 2010-12-06 19:39:23 Re: Union Question