Howto convert floats to text?

From: Martin Leja <martin(at)unix-ag(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Howto convert floats to text?
Date: 1999-06-04 10:45:22
Message-ID: 199906041045.GAA67778@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

there are the following functions to convert types other than text to text:

$bash psql -c "\df" | sed -n '1,2 p; /^text.*convert/ p'

return_type|function |arguments |description

-----------+------------------+--------------------+------------------------
----
text |datetime_text |datetime |convert

text |int2_text |int2 |convert

text |int4_text |int4 |convert

text |oid_text |oid |convert

text |text |datetime |convert

text |text |timespan |convert

text |text |int4 |convert

text |text |int2 |convert

text |text |oid |convert

text |timespan_text |timespan |convert

is there realy no function to convert a float to text?

--
Regards, martin(at)unix-ag(dot)org

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Klemme 1999-06-04 12:14:49 SQL Problem: ERROR: ExecEvalExpr: unknown expression type 108
Previous Message Vikrant Rathore 1999-06-04 08:01:31 Mail about select