pgsql: Add the full set of comparison functions for type TID, including

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add the full set of comparison functions for type TID, including
Date: 2006-07-21 20:51:33
Message-ID: 20060721205133.6A56B9FB1B8@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2006-07-21 22:37:37 pgsql: For automatic dependency tracking, replace our sed hackery with
Previous Message User Gsmet 2006-07-21 10:26:44 pgfouine - pgfouine: more work on vacuum verbose output analysis