Re: [HACKERS] Re: [GENERAL] A mistake generates strange result - Mailing list pgsql-hackers

>>>> 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