|
Home > Archive > PostgreSQL Bugs > November 2005 > BUG #2040: buggy cast of INT8 to text
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BUG #2040: buggy cast of INT8 to text
|
|
| Sebastien MAYER 2005-11-14, 9:24 am |
|
The following bug has been logged online:
Bug reference: 2040
Logged by: Sebastien MAYER
Email address: sebastien.mayer@briosoft.com
PostgreSQL version: 8.04
Operating system: Linux Fedora core 4
Description: buggy cast of INT8 to text
Details:
in plpgsql :
declare
var_text text;
var_int8 INT8;
begin
var_int8 := 123456;
-- next line give some strange result... but not always
var_text := 'the value of var_int8 is ' || var_int8;
.....
end;
I wrote a small b_bigint_to_text(int
8) returns text
and will use it until i see some fix on this.
More generally, the oid, wich is int4 does not fit the currval, nextvall etc
wich returns int8. Since you moved the serial concept from 32 bits to 64
bits (which look good to me), you still have old 32 bits style functions and
variable (oid !) mixed with the new 64 bits concept.
But, i thanks you everyday of my programmer life anyway !!!!!
seb
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Tom Lane 2005-11-14, 11:24 am |
| "Sebastien MAYER" <sebastien.mayer@briosoft.com> writes:
> -- next line give some strange result... but not always
> var_text := 'the value of var_int8 is ' || var_int8;
Couldn't duplicate a problem here ... you need to give a reproducible
test case if you want anyone to look into this.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|