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:37:05 -0500
Message-ID: <1291757825.16970.18.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: <1291757825.16970.18.camel@tony1.localdomain>
Permalink:  ../1291757825.16970.18.camel@tony1.localdomain/
Also on:    postgresql.org/message-id/1291757825.16970.18.camel@tony1.localdomain

 · 

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: <1291757825.16970.18.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