Michael Nolan <htfoot@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
