concatenate question
От | Tony Capobianco |
---|---|
Тема | concatenate question |
Дата | |
Msg-id | 1291756033.16970.11.camel@tony1.localdomain обсуждение исходный текст |
Ответы |
Re: concatenate question
|
Список | 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.
В списке pgsql-sql по дате отправления: