Like many other languages, PostgreSQL supports the !=
comparison operator.
> select category from animals where datatype != datatype;
PostgreSQL also supports the <>
comparison operator, and actually converts !=
into <>
during parsing.
> select category from animals where datatype <> datatype;