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
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 |