Unfortunately, that is true, at least for Postgres 6.4.0:
template1=> select text('12345678'::float8);
text
-----------------------------
Tue May 23 00:21:18 2000 EEST
(1 row)
Please, guys, take care of this small bug:-)
Aleksey
On 9 Feb 1999, [ISO-8859-1] St�phane Dupille wrote:
>
> Hi !
>
> "Ricardo J.C.Coelho" <pulsar@truenet-ce.com.br> writes:
> > 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 !!!!!!
>
> I didn't found any function of name "text" that converts
> float8 to text. So I think Postgres made an implicit cast of the data
> to datatime. So: String->Float8->DateTime->Text. Stranger : I didn't
> found any function to cinvert float to text !
>
> > If you use: select ('12345678'::float8)::text; everything runs well.
>
> Here, you made an explicit cast, without the use of any
> function. So your data is casted well.
>
> Hope this helps !
>
>