A mistake generates strange result - Mailing list pgsql-general

From Ricardo J.C.Coelho
Subject A mistake generates strange result
Date
Msg-id 01BE53A3.90BE0720.pulsar@truenet-ce.com.br
Whole thread Raw
Responses How do I unsubscribe?
List pgsql-general
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.



pgsql-general by date:

Previous
From: Clark Evans
Date:
Subject: ODMG.ORG
Next
From: "Ricardo J.C.Coelho"
Date:
Subject: Check constraint memory problem