Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199406132104.OAA03234@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <9406132102.AA46554@whale.st.usm.edu>
Subject: Floating-point precision in displays
To: postgres@postgres.Berkeley.EDU
Date: Mon, 13 Jun 1994 16:02:08 -0500 (CDT)
From: Billy.Chambless@whale.st.usm.edu
Reply-To: chambles@whale.st.usm.edu
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 371       
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 13 Jun 94 14:04:30 -0700
Resent-XMts: smtp

Is there a way to specify the number of decimal places
with which to display floating point numbers?

I'm using a lot of "float4"s in my db, and the postgres monitor
displays them in scientific notation--not pretty.

Is there a built-in that I'm missing, or do I need to write  
a special display function?
-- 
* In Real Life: Billy Chambless * chambles@whale.st.usm.edu

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================