First cut at making useful selectivity estimates for range queries
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 24 Jan 2000 07:16:52 +0000 (07:16 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 24 Jan 2000 07:16:52 +0000 (07:16 +0000)
commit0dbffa704ab3235431b4caef675d9179109d4a0c
treee00f27de3b6a2faec151f4d2d6aa924ba05d5e5d
parent8bcac56086ec1aa1eae04879bfb22275b9396522
First cut at making useful selectivity estimates for range queries
(ie, WHERE x > lowbound AND x < highbound).  It's not very bright yet
but it does something useful.  Also, rename intltsel/intgtsel to
scalarltsel/scalargtsel to reflect usage better.  Extend convert_to_scalar
to do something a little bit useful with string data types.  Still need
to make it do something with date/time datatypes, but I'll wait for
Thomas's datetime unification dust to settle first.  Eventually the
routine ought not have any type-specific knowledge at all; it ought to
be calling a type-dependent routine found via a pg_type column; but
that's a task for another day.
doc/src/sgml/xindex.sgml
doc/src/sgml/xoper.sgml
src/backend/optimizer/path/clausesel.c
src/backend/utils/adt/selfuncs.c
src/include/catalog/catversion.h
src/include/catalog/pg_operator.h
src/include/catalog/pg_proc.h
src/include/utils/builtins.h
src/tutorial/complex.source