From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: concatenate question |
Date: | 2010-12-11 13:42:59 |
Message-ID: | 20101211134259.GA12385@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tony Capobianco <tcapobianco(at)prospectiv(dot)com> wrote:
> Here's my table:
>
> plsql_dw=# \d tmpsv_parent_master
> Table "staging.tmpsv_parent_master"
>
> 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.
You can read? ;-)
You have to CAST the INT and the TIMESTAMP both into a STRING-typ, for
instance:
test=*# select 1::int || now()::timestamp;
ERROR: operator does not exist: integer || timestamp without time zone
ZEILE 1: select 1::int || now()::timestamp;
^
TIP: No operator matches the given name and argument type(s). You might need to add explicit type casts.
test=!# rollback;
ROLLBACK
Zeit: 0,124 ms
test=# select 1::text || now()::text;
?column?
--------------------------------
12010-12-11 14:42:12.571931+01
(1 Zeile)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2010-12-13 09:18:29 | Re: Regular Expression Match Operator escape character |
Previous Message | Thomas Kellerer | 2010-12-11 10:50:06 | Re: sqlplus reporting equivalent in postgres? |