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)
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 |