Skip site navigation (1) Skip section navigation (2)

RestrictionClauseSelectivity

From: "Michael R(dot) Anderson" <mike(at)ferrar(dot)wvsc(dot)edu>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: RestrictionClauseSelectivity
Date: 2001-03-08 15:53:52
Message-ID: 01C0A7BE.1139CF40.mike@ferrar.wvsc.edu (view raw or flat)
Thread:
Lists: pgsql-novice
 March 8, 2001
  
  I have a Postgresql 6.4.2 database.  I added a char(2) field (call it 
  'foo') to one of the tables (call it 'table1') using the ALTER TABLE 
  command.  When I try this command:
  
  select * from table1 where foo='1';
  
  I get the error message:
  
  ERROR: RestrictionClauseSelectivity: bad value 2.450299
  
  What does this mean and how do I fix it?
  
  Two notes:
  
  1. Doing a select on other fields in table1 work fine, and the added field displays correctly.
  2. I have the same database for Postgresql 6.5.? and I don't get the error 
  message.  Upgrading the database with the problem can't be done at the 
  moment.
  
  Regards,
  
  Mike Anderson
  


Responses

pgsql-novice by date

Next:From: Poul L. ChristiansenDate: 2001-03-08 15:56:17
Subject: Re: List Tables !
Previous:From: Boulat KhakimovDate: 2001-03-08 15:51:25
Subject: Re: List Tables !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group