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