]> granicus.if.org Git - postgresql/commit
Add new selectivity estimation functions for pattern-matching operators
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 16 Apr 2000 04:41:03 +0000 (04:41 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 16 Apr 2000 04:41:03 +0000 (04:41 +0000)
commit82849df6c637c09fe484ed11e1035c158f128e81
treeddb8f0f3af666ad331ae05498bd039d2e65e783f
parent8c3b52e7b2d90a35be1370a10fcf02218fa4ae99
Add new selectivity estimation functions for pattern-matching operators
(LIKE and regexp matches).  These are not yet referenced in pg_operator,
so by default the system will continue to use eqsel/neqsel.
Also, tweak convert_to_scalar() logic so that common prefixes of strings
are stripped off, allowing better accuracy when all strings in a table
share a common prefix.
doc/src/sgml/xoper.sgml
src/backend/optimizer/path/indxpath.c
src/backend/utils/adt/selfuncs.c
src/include/catalog/pg_proc.h
src/include/utils/builtins.h