pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Leja <martin@unix-ag.org>
To: pgsql-sql@postgresql.org
Subject: Howto convert floats to text?
Date: Fri, 04 Jun 1999 12:45:22 +0200
Message-ID: <199906041045.GAA67778@hub.org> (raw)

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



view thread (4+ messages)  latest in thread

Message-ID: <199906041045.GAA67778@hub.org>
Permalink:  ../199906041045.GAA67778@hub.org/
Also on:    postgresql.org/message-id/199906041045.GAA67778@hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: martin@unix-ag.org
  Subject: Re: Howto convert floats to text?
  In-Reply-To: <199906041045.GAA67778@hub.org>
  References: <199906041045.GAA67778@hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox