I am not sure if this belongs in pgsql-general or pgsql-hackers, I am
trying first in psgl-general.
Doesn't matter a lot, but as Rob noted, you should not hijack an
existing thread. Start your own thread, don't reply to an unrelated
message.
My apologies.
I don't see any discrepancy in your results, only in your choices of
printf specifiers. "%f" defaults to "%.6f", that is, print only six
digits after the decimal point. So a value down around 1e-12 is
going to print as all zeroes.
Agreed. I should have noticed that my self.
Greg