>> 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