postgresql - query with not equal doesn't work -

postgresql - query with not equal doesn't work -

this dumb question still, i'm trying write not equal clause postgresql documentation show sign <> or != both homecoming 0 results on integer field.

select userid users usertype <> 2; select userid users usertype != 2;

the table looks this:

create table users( userid bigserial primary key not null, name varchar (50) not null, phonenumber varchar (20) unique not null, usertype integer null );

note: next workaround worka , homecoming results

select userid users usertype < 2 or usertype > 2;

i wondering if encounter same problem?

postgresql