Return-Path: owner-postman Received: from LOCALHOST (LOCALHOST [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA04994 for postgres-redist; Mon, 13 Jun 1994 14:37:20 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199406132137.OAA04994@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from LOCALHOST (LOCALHOST [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA04982; Mon, 13 Jun 1994 14:37:19 -0700 Message-Id: <199406132137.OAA04982@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host LOCALHOST didn't use HELO protocol From: aoki@CS.Berkeley.EDU (Paul M. Aoki) To: chambles@whale.st.usm.edu Cc: postgres@postgres.Berkeley.EDU Subject: Re: Floating-point precision in displays Reply-To: aoki@CS.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Mon, 13 Jun 1994 16:02:08 -0500 (CDT) <9406132102.AA46554@whale.st.usm.edu> Date: Mon, 13 Jun 94 14:37:19 -0700 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 13 Jun 94 14:37:20 -0700 Resent-XMts: smtp Billy.Chambless@whale.st.usm.edu writes: > 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? no, you're not missing anything. float4_out just calls sprintf with %g. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@CS.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki ============================================================================== 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. ==============================================================================