Re: PostgreSQL 6.4.2: float8::text (fwd)

Hello!

A friend of me got errors with float8, so I forward his questions here.
AFAIK last error (float8-to-date) had been fixed in CURRENT, but what
about other errors?

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

---------- Forwarded message ----------
Date: Wed, 17 Mar 1999 12:34:05 +0300 (MSK)
From: Artem Chuprina <ran(at)pirit(dot)com>
To: phd(at)sun(dot)med(dot)ru
Subject: Re: PostgreSQL 6.4.2: float8::text

ran=> create table test (f float4, ff float8);
CREATE
ran=> insert into test values (0,0);
INSERT 149524 1
ran=> select f||'$' from test;
ERROR: There is more than one possible operator '||' for types 'float4' and 'unknown'
You will have to retype this query using an explicit cast
ran=> select ff||'$' from test;
ERROR: There is more than one possible operator '||' for types 'float8' and 'unknown'
You will have to retype this query using an explicit cast
ran=> select f::text from test;
ERROR: Function 'text(float4)' does not exist
There is more than one function that satisfies the given argument types
You will have to retype your query using explicit typecasts
ran=> select ff::text from test;
text
----------------------------
Sat Jan 01 03:00:00 2000 MSK
(1 row)