============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Peter Lemieux
Your email address : phl@cyways.com
Category : unknown
Severity : non-critical
Summary: RestrictionClauseSelectivity: bad value 2.302734
System Configuration
- --------------------
Operating System : RedHat 4.2 + Linux 2.0.34 ELF
PostgreSQL version : 6.4
Compiler used : gcc 2.7
Hardware:
- ---------
Pentium 133 32 meg
Versions of other tools:
- ------------------------
- --------------------------------------------------------------------------
Problem Description:
- --------------------
I HAVE REPORTED THIS BEFORE WITHOUT HEARING ANY RESPONSE.
Nor can I find any mention of this in the mailing list
archives or any other reference document.
When restricting a select with a where clause that employs
a varchar field, I'll often get the response:
RestrictionClauseSelectivity: bad value 2.302734
The value is always 2.302734.
- --------------------------------------------------------------------------
Test Case:
- ----------
- --------------------------------------------------------------------------
Solution:
- ---------
- --------------------------------------------------------------------------