From: Tony Capobianco <tcapobianco@prospectiv.com>
To: pgsql-sql@postgresql.org
Subject: Re: concatenate question
Date: Tue, 07 Dec 2010 16:47:46 -0500
Message-ID: <1291758466.16970.19.camel@tony1.localdomain> (raw)
In-Reply-To: <AANLkTi=cdwqU0DtFf68BuD=wb3tWfCToe4hn_AUWJFpQ@mail.gmail.com>
References: <1291757825.16970.18.camel@tony1.localdomain>
<AANLkTi=cdwqU0DtFf68BuD=wb3tWfCToe4hn_AUWJFpQ@mail.gmail.com>
Ok, that worked. Why did I need to cast both as text though?
plsql_dw=# select memberid::text||addeddate::text from
tmpsv_parent_master limit 5;
?column?
------------------------------
4005941032010-11-16 19:32:17
4005941952010-11-16 19:33:29
4005942842010-11-16 19:34:32
4005943492010-11-16 19:35:22
4005943662010-11-16 19:35:37
(5 rows)
Thanks.
On Tue, 2010-12-07 at 16:43 -0500, Peter Steinheuser wrote:
> I think the HINT is what you need to look at.
>
> Cast both columns to text.
>
> On Tue, Dec 7, 2010 at 4:37 PM, Tony Capobianco
> <tcapobianco@prospectiv.com> wrote:
> 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.
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
>
>
> --
> Peter Steinheuser
> psteinheuser@myyearbook.com
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: <1291758466.16970.19.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