pgsql: Add the full set of comparison functions for type TID, including - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Add the full set of comparison functions for type TID, including
Date
Msg-id 20060721205133.6A56B9FB1B8@postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: gsmet@pgfoundry.org (User Gsmet)
Date:
Subject: pgfouine - pgfouine: more work on vacuum verbose output analysis
Next
From: petere@postgresql.org (Peter Eisentraut)
Date:
Subject: pgsql: For automatic dependency tracking, replace our sed hackery with