Re: using xmin in a query? - Mailing list pgsql-general

Michael Nolan <htfoot@gmail.com> writes:
> Why does this query succeed:
> select count(*) from tablename where xmin = 2

> while this query fails:

> select count(*) from tablename where xmin != 2

It told you why not:

> ERROR:  operator does not exist: xid <> integer

You could do "where not (xmin = 2)", I suppose.

            regards, tom lane