Thread: pgsql: Add the full set of comparison functions for type TID, including
pgsql: Add the full set of comparison functions for type TID, including
From
tgl@postgresql.org (Tom Lane)
Date:
Log Message:
-----------
Add the full set of comparison functions for type TID, including a btree
opclass. This is not so much because anyone's likely to create an index
on TID, as that sorting TIDs can be useful. Also added max and min
aggregates while at it, so that one can investigate the clusteredness of
a table with queries like SELECT min(ctid), max(ctid) FROM tab WHERE ...
Greg Stark and Tom Lane
Modified Files:
--------------
pgsql/src/backend/utils/adt:
tid.c (r1.53 -> r1.54)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tid.c.diff?r1=1.53&r2=1.54)
pgsql/src/include/catalog:
catversion.h (r1.338 -> r1.339)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.338&r2=1.339)
pg_aggregate.h (r1.54 -> r1.55)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_aggregate.h.diff?r1=1.54&r2=1.55)
pg_amop.h (r1.72 -> r1.73)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_amop.h.diff?r1=1.72&r2=1.73)
pg_amproc.h (r1.58 -> r1.59)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_amproc.h.diff?r1=1.58&r2=1.59)
pg_opclass.h (r1.70 -> r1.71)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_opclass.h.diff?r1=1.70&r2=1.71)
pg_operator.h (r1.143 -> r1.144)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_operator.h.diff?r1=1.143&r2=1.144)
pg_proc.h (r1.415 -> r1.416)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.415&r2=1.416)
pgsql/src/include/utils:
builtins.h (r1.279 -> r1.280)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h.diff?r1=1.279&r2=1.280)