Horton

Re: [HACKERS] Re: [GENERAL] A mistake generates strange result

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: Postgres DBA <postgres@nest.bistbn.com>
Cc: pgsql-hackers@postgreSQL.org
Date: 1999-02-10T15:26:49Z
Lists: pgsql-hackers 
> Unfortunately, that is true, at least for Postgres 6.4.0:
> template1=> select text('12345678'::float8);
> -----------------------------
> Tue May 23 00:21:18 2000 EEST
> Please, guys, take care of this small bug:-)

tgl=> select text('12345678'::float8);
    text
--------
12345678
(1 row)

Already done. From the cvs log:

revision 1.84
date: 1998/11/17 14:36:51;  author: thomas;  state: Exp;  lines: +34 -15
Add text<->float8 and text<->float4 conversion functions.
This will fix the problem reported by Jose' Soares
 when trying to cast a float to text.

                         - Tom