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