A mistake generates strange result

From: "Ricardo J(dot)C(dot)Coelho" <pulsar(at)truenet-ce(dot)com(dot)br>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: A mistake generates strange result
Date: 1999-02-08 22:21:11
Message-ID: 01BE53A3.90BE0720.pulsar@truenet-ce.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ricardo J.C.Coelho 1999-02-08 22:38:30 palloc with user's functions
Previous Message Ricardo J.C.Coelho 1999-02-08 22:10:22 Check constraint memory problem

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-02-08 23:55:34 Re: [HACKERS] Problems with >2GB tables on Linux 2.0
Previous Message Thomas Reinke 1999-02-08 21:34:22 Re: [HACKERS] Problems with >2GB tables on Linux 2.0