RestrictionClauseSelectivity - Mailing list pgsql-sql

From Frank Bax
Subject RestrictionClauseSelectivity
Date
Msg-id 3.0.6.32.19991130214502.0098deb0@execulink.com
Whole thread Raw
Responses Re: [SQL] RestrictionClauseSelectivity  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
DROP TABLE   Players;
CREATE TABLE Players ( ReqWhen DATETIME );
ALTER TABLE  Players  ADD  ReqCode   TEXT;
ALTER TABLE  Players  ADD  ReqName   TEXT;
ALTER TABLE  Players  ADD  ReqMail   TEXT;
ALTER TABLE  Players  ADD  ReqPlay   TEXT;
ALTER TABLE  Players  ADD  ReqFeed   TEXT;
ALTER TABLE  Players  ADD  ReqPend   CHAR;
SELECT * FROM Players WHERE ReqCode = 'Test';

Always produces the following error message:

ERROR:  RestrictionClauseSelectivity: bad value 2.451276

I'm on 6.4.2 I think.  Whatever was on RedHat 6.0 CD.
How do I confirm version without the install files?

Frank Bax


pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: RestrictionClauseSelectivity
Next
From: Chris Griffin
Date:
Subject: Many booleans