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
