agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFloating-point precision in displays
2+ messages / 2 participants
[nested] [flat]
* Floating-point precision in displays
@ 1994-06-13 21:02 Billy.Chambless@whale.st.usm.edu
0 siblings, 1 reply; 2+ messages in thread
From: Billy.Chambless@whale.st.usm.edu @ 1994-06-13 21:02 UTC (permalink / raw)
To: legacy
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.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Floating-point precision in displays
@ 1994-06-13 21:37 Paul M. Aoki <aoki@CS.Berkeley.EDU>
parent: Billy.Chambless@whale.st.usm.edu
0 siblings, 0 replies; 2+ messages in thread
From: Paul M. Aoki @ 1994-06-13 21:37 UTC (permalink / raw)
To: chambles@whale.st.usm.edu; +Cc: legacy
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.
==============================================================================
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1994-06-13 21:37 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-06-13 21:02 Floating-point precision in displays Billy.Chambless@whale.st.usm.edu
1994-06-13 21:37 ` Paul M. Aoki <aoki@CS.Berkeley.EDU>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox