On Fri, 2005-12-02 at 14:09 -0500, Bruce Momjian wrote: > I ran your SELECT pow(10::numeric, 131071), and gain, 4096 0's are > displayed on my screen. SELECT pow(10::numeric, 7000) and SELECT > pow(10::numeric, 10000) generate identical displays on my screen.
Are you saying there is a bug with or without my patch? Can we get the usual release levels/cvstip, ports, etc. Are you connecting across network/ protocol differences... [Just out of interest, has anybody ever used a number bigger than 10^20 in an application? My understanding is that the number of atoms in the universe is around 10^80. Accuracy is needed during calculation, but much less so during storage.] Thanks, Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings