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


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: (view raw, whole thread or download thread mbox)
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 
  Mike Anderson


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-2017 The PostgreSQL Global Development Group