Thread

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

Oleg Broytmann <phd@sun.med.ru> — 1999-03-17T10:05:48Z

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@earthling.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@pirit.com>
To: phd@sun.med.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)