pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tony Capobianco <tcapobianco@prospectiv.com>
To: pgsql-sql@postgresql.org
Subject: concatenate question
Date: Tue, 07 Dec 2010 16:07:13 -0500
Message-ID: <1291756033.16970.11.camel@tony1.localdomain> (raw)

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.

view thread (11+ messages)  latest in thread

Message-ID: <1291756033.16970.11.camel@tony1.localdomain>
Permalink:  ../1291756033.16970.11.camel@tony1.localdomain/
Also on:    postgresql.org/message-id/1291756033.16970.11.camel@tony1.localdomain

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tcapobianco@prospectiv.com
  Subject: Re: concatenate question
  In-Reply-To: <1291756033.16970.11.camel@tony1.localdomain>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox