Re: String concat issues in 8.3.1 (8.3.1 bug?) - Mailing list pgsql-general

am  Thu, dem 17.04.2008, um  3:05:14 -0600 mailte kevin kempter folgendes:
> However in the 8.3.1 cluster I get this (Both clusters have the same
> data set - via a pg_dump):
>
> # select customer_srcid || segment_srcid from test_dim;
> ERROR:  operator does not exist: bigint || bigint
> LINE 1: select customer_srcid || segment_srcid from sl_segment_dim;
>                               ^
> HINT:  No operator matches the given name and argument type(s). You
> might need to add explicit type casts.
>
>
>
>
> Thoughts ?

You have to cast int-values to text, untested:

select customer_srcid::text || segment_srcid::text ...



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net