Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Jeff MacDonald
Your email address : jeff(at)hub(dot)org

Category : runtime: front-end
Severity : non-critical

Summary: ERROR:RestrictionClauseSelectivity: bad value 164739.656250

System Configuration
--------------------
Operating System : Free BSD 3.2

PostgreSQL version : 6.4.2

Compiler used : gcc

Hardware:
---------
Pentium II 400, 384 MB ram
FreeBSD hub.org 3.2-STABLE FreeBSD 3.2-STABLE #0:i386

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
here's the table schema

Table = psql_cds
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| id | int4 not null default nextval ( | 4 |
| name | varchar() | 25 |
| cds_ordered | int4 | 4 |
| cds_sent | int4 | 4 |
| mostrecent_sent | float8 | 8 |
+----------------------------------+----------------------------------+-------+

jeff=> select * from psql_cds where mostrecent_sent=6.5;
ERROR: RestrictionClauseSelectivity: bad value 164739.656250

--------------------------------------------------------------------------

Test Case:
----------
make a table like above, fill in some values,
run that select statement..

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------