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.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
