RestrictionClauseSelectivity error on select - Mailing list pgsql-novice

From danny@lennon.postino.com
Subject RestrictionClauseSelectivity error on select
Date
Msg-id 200008130409.VAA19971@lennon.postino.com
Whole thread Raw
Responses Re: RestrictionClauseSelectivity error on select  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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 .
I am at a loss to figure out why the select is failing.
Any help appreciated.

--
Danny Aldham     Providing Certified Internetworking Solutions to Business
www.postino.com  E-Mail, Web Servers, Web Databases, SQL PHP & Perl

pgsql-novice by date:

Previous
From: "Paul Skinner"
Date:
Subject: PGTCL
Next
From: Tom Lane
Date:
Subject: Re: RestrictionClauseSelectivity error on select