Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250

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


Your name               : Jeff MacDonald
Your email address      : jeff@hub.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:
---------


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