RestrictionClauseSelectivity

From: Frank Bax <fbax(at)execulink(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: RestrictionClauseSelectivity
Date: 1999-12-01 02:45:02
Message-ID: 3.0.6.32.19991130214502.0098deb0@execulink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-12-01 03:07:28 Re: [SQL] RestrictionClauseSelectivity
Previous Message Frank Bax 1999-12-01 01:35:34 RestrictionClauseSelectivity