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.
