From: | kevin kempter <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | String concat issues in 8.3.1 (8.3.1 bug?) |
Date: | 2008-04-17 09:05:14 |
Message-ID: | 660021BC-C69E-442D-91E2-829DEC6196C6@kevinkempterllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a table as follows:
\d test_dim
Table "public.test_dim"
Column | Type | Modifiers
-----------------+-----------------------------+------------------------
customer_srcid | bigint | not null
segment_srcid | bigint | not null
show_name | character varying(500) | not null
create_dt | timestamp without time zone | not null default now()
I have this table in a db on an 8.2.6 cluster and in another db on an
8.3.1 cluster.
In both clusters I can do the following:
# select customer_srcid, segment_srcid from test_dim;
customer_srcid | segment_srcid
----------------+---------------
1 | 1
1 | 2
1 | 3
1 |
1 |
1 |
1 | 1
1 | 2
1 | 3
1 |
1 |
1 |
1 | 1
1 | 2
1 | 3
1 |
1 |
1 |
1 | 1
1 | 2
1 | 3
1 |
1 |
1 |
(24 rows)
In version 8.2.6 I can do this:
# select customer_srcid || segment_srcid from test_dim;
?column?
----------
11
12
13
11
12
13
11
12
13
11
12
13
(24 rows)
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 ?
Thanks in advance
/Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2008-04-17 09:12:22 | Re: String concat issues in 8.3.1 (8.3.1 bug?) |
Previous Message | Stefan Sturm | 2008-04-17 08:41:29 | Re: Storing and accessing GeoData( Latitude and Longitude ) in PostgreSQL 8.3 |