danny(at)lennon(dot)postino(dot)com writes:
> I am trying to do a select * from table where column like '%pattern%' ;
> from a varchar field, and am getting the error:
> RestrictionClauseSelectivity : bad value - 1.98625 error .
Short term solution: VACUUM ANALYZE to fix bogus statistical data.
Long term solution: update to a newer pgsql release. The bug that
causes creation of the bogus stats has been fixed since 6.5 or so,
IIRC.
regards, tom lane