Re: help debugging an issue with selectivity

Greg Hennessy <greg.hennessy@gmail.com>

From: Greg Hennessy <greg.hennessy@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-general@lists.postgresql.org
Date: 2026-03-18T15:56:20Z
Lists: pgsql-general
>> 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