Received: from amsterdam.execulink.net (mail.execulink.com [199.166.6.19]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA70915 for ; Tue, 30 Nov 1999 20:31:11 -0500 (EST) (envelope-from fbax@execulink.com) Received: from bax7 (ppp58.d2-1.56k.execulink.com [209.239.11.122]) by amsterdam.execulink.net (8.9.3/8.9.3) with SMTP id UAA15342 for ; Tue, 30 Nov 1999 20:31:07 -0500 (EST) Message-Id: <3.0.6.32.19991130203534.01090ba0@execulink.com> X-Sender: fbax@execulink.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Tue, 30 Nov 1999 20:35:34 -0500 To: pgsql-sql@postgresql.org From: Frank Bax Subject: RestrictionClauseSelectivity Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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