Re: != and <> operators - Mailing list pgsql-sql

From Tom Lane
Subject Re: != and <> operators
Date
Msg-id 19227.984495852@sss.pgh.pa.us
Whole thread Raw
In response to != and <> operators  (Patrik Kudo <kudo@partitur.se>)
Responses Re: != and <> operators
List pgsql-sql
Patrik Kudo <kudo@partitur.se> writes:
> I've for a while now been using the != operator in my sql queries, but in
> almost all examples I see <> instead. Are there any good reason to use
> any instead of the other? I prefer !=, but if you convince me, I'll change to
> what you other guys are using ;-)

"<>" is the SQL-standard name, and also the internal name of all these
operators.  There is a hardwired hack in the lexer to convert != to <>.
So write whichever you feel like, but <> is what you'll see in dumps and
so forth ...
        regards, tom lane


pgsql-sql by date:

Previous
From: "Rob Arnold"
Date:
Subject: Re: Permissons on database
Next
From: Richard Poole
Date:
Subject: Re: Re: Use of the LIMIT clause ?