Re: XID Data Types

Manfred Koizar <mkoi-pg@aon.at>

From: Manfred Koizar <mkoi-pg@aon.at>
To: Ericson Smith <eric@did-it.com>
Cc: pgsql-general@postgresql.org
Date: 2004-05-03T18:36:33Z
Lists: pgsql-general
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.