RestrictionClauseSelectivity - Mailing list pgsql-sql

From Frank Bax
Subject RestrictionClauseSelectivity
Date
Msg-id 3.0.6.32.19991130203534.01090ba0@execulink.com
Whole thread Raw
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 (no need to add data):

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: Mark Kirkwood
Date:
Subject: slow sort for simple join
Next
From: Frank Bax
Date:
Subject: RestrictionClauseSelectivity