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:37:05
Message-ID: 1291757825.16970.18.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 Peter Steinheuser 2010-12-07 21:43:43 Re: concatenate question
Previous Message Tony Capobianco 2010-12-07 21:07:13 concatenate question