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.
