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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers