RestrictionClauseSelectivity error on select

From: danny(at)lennon(dot)postino(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: RestrictionClauseSelectivity error on select
Date: 2000-08-13 04:09:23
Message-ID: 200008130409.VAA19971@lennon.postino.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2000-08-13 04:38:11 Re: RestrictionClauseSelectivity error on select
Previous Message Paul Skinner 2000-08-11 15:23:43 PGTCL