>>>> The query: select text('12345678'::float8);
>>>> It returns a date in datetime format !!!!!!
Yup, I see it here also with 6.4.2.
The current development sources seem OK however:
regression=> select text('12345678'::float8);
text
--------
12345678
(1 row)
So it should be fixed in 6.5. (Thomas, could this be back-patched
into 6.4.3?)
regards, tom lane