Received: from MAIL.hrz.uni-siegen.de (maila.hrz.uni-siegen.de [141.99.11.1]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA67778 for ; Fri, 4 Jun 1999 06:45:01 -0400 (EDT) (envelope-from martin@unix-ag.org) Message-Id: <199906041045.GAA67778@hub.org> Received: from ga52124b (ga52124.ga.wohnheim.uni-siegen.de [141.99.25.155]) by MAIL.hrz.uni-siegen.de with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id MDZ6R1MJ; Fri, 4 Jun 1999 12:44:49 +0200 X-Sender: martin@vmax.unix-ag.org X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0.1 Date: Fri, 04 Jun 1999 12:45:22 +0200 To: pgsql-sql@postgresql.org From: Martin Leja Subject: Howto convert floats to text? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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@unix-ag.org