On Wed, Dec 01, 2004 at 20:25:28 -0300, Clodoaldo Pinto <[EMAIL PROTECTED]> wrote: > The 7.4.2 manual says the precision of a real number is 6 decimal digits. > > Is it possible to force the display of more than six decimal digits of a real > number whithout using to_char() or casting?
I think you can use the extra_float_digits GUC variable to do what you want. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match