CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl@svr1.postgresql.org 03/11/12 17:15:59
Modified files:
contrib/dblink : dblink.c
contrib/miscutil: misc_utils.c
doc/src/sgml : catalogs.sgml xindex.sgml
src/backend/access/common: scankey.c
src/backend/access/gist: gistget.c gistscan.c
src/backend/access/heap: tuptoaster.c
src/backend/access/nbtree: nbtcompare.c nbtinsert.c nbtree.c
nbtsearch.c nbtsort.c nbtutils.c
src/backend/access/rtree: rtproc.c rtscan.c
src/backend/catalog: aclchk.c dependency.c heap.c index.c
pg_constraint.c pg_conversion.c pg_depend.c
pg_largeobject.c
src/backend/commands: async.c cluster.c comment.c dbcommands.c
functioncmds.c indexcmds.c opclasscmds.c
tablecmds.c trigger.c typecmds.c user.c
vacuum.c
src/backend/executor: nodeIndexscan.c
src/backend/nodes: copyfuncs.c outfuncs.c
src/backend/optimizer/path: indxpath.c
src/backend/optimizer/plan: createplan.c
src/backend/optimizer/util: plancat.c
src/backend/parser: parse_func.c
src/backend/rewrite: rewriteRemove.c
src/backend/storage/large_object: inv_api.c
src/backend/utils/adt: float.c regproc.c ruleutils.c selfuncs.c
src/backend/utils/cache: catcache.c lsyscache.c relcache.c
syscache.c typcache.c
src/backend/utils/init: postinit.c
src/backend/utils/sort: tuplesort.c
src/include/access: nbtree.h skey.h
src/include/catalog: catversion.h indexing.h namespace.h
pg_amop.h pg_amproc.h pg_opclass.h
pg_proc.h
src/include/nodes: plannodes.h
src/include/utils: builtins.h geo_decls.h lsyscache.h rel.h
src/test/regress/expected: create_index.out oidjoins.out
opr_sanity.out
src/test/regress/sql: create_index.sql oidjoins.sql
opr_sanity.sql
Log message:
Cross-data-type comparisons are now indexable by btrees, pursuant to my
pghackers proposal of 8-Nov. All the existing cross-type comparison
operators (int2/int4/int8 and float4/float8) have appropriate support.
The original proposal of storing the right-hand-side datatype as part of
the primary key for pg_amop and pg_amproc got modified a bit in the event;
it is easier to store zero as the 'default' case and only store a nonzero
when the operator is actually cross-type. Along the way, remove the
long-since-defunct bigbox_ops operator class.