Re: XID Data Types

Jan Wieck wrote:
> Manfred Koizar wrote:
> > On Mon, 03 May 2004 13:38:45 -0400, Ericson Smith <eric@did-it.com>
> > wrote:
> >>didit=# select *,xmin from settings where xmin > '187167023'::xid limit 5;
> >>ERROR:  operator does not exist: xid > xid
> >
> > There might be better solutions, but when I ran into the same problem,
> > the age(xid) function helped at lot.
>
> Slony contains an xxid data type that follows exactly the xid semantics.
> It comes with a full operator class so that you can even put indexes on
> xxid type columns. Shouldn't be too hard to define those operators for
> the builtin xid type instead.

Should we just get that into our CVS so Slony doesn't have to distribute
its own?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073