A mistake generates strange result

Ricardo J.C.Coelho <pulsar@truenet-ce.com.br>

From: "Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br>
To: "pgsql-general@postgreSQL.org" <pgsql-general@postgreSQL.org>
Date: 1999-02-08T22:21:11Z
Lists: pgsql-hackers
Just for PgSQL's development group think about....

I made a mistake typing a query that generates a strange result (Very strange). 

The query: select text('12345678'::float8);

It returns a date in datetime format !!!!!!

If you use: select ('12345678'::float8)::text;        everything runs well.