> 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' Soareswhen trying to cast a float to text.
- Tom