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
