Re: Change behavior of (m)xid_age

On 2015-10-22 18:07:06 -0400, Robert Haas wrote:
> > BTW, ignoring relfrozenxid = 0 also isn't as easy as you'd think:
> >
> > select count(*) from pg_class where relfrozenxid <> 0;
> > ERROR:  operator does not exist: xid <> integer at character 50
> 
> It takes a few more characters than that, but it's not really that hard.
> 
> rhaas=# select count(*) from pg_class where relfrozenxid::text <> '0';

"WHERE NOT relfrozenxid = 0" should work as well and is a bit nicer.

FWIW, adding an <> operator for xid seems like a perfectly good idea.

- Andres