Re: != and <> operators

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: != and <> operators
Дата
Msg-id 19227.984495852@sss.pgh.pa.us
обсуждение исходный текст
Ответ на != and <> operators  (Patrik Kudo <kudo@partitur.se>)
Ответы Re: != and <> operators  (Patrik Kudo <kudo@partitur.se>)
Список 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 по дате отправления:

Предыдущее
От: "Rob Arnold"
Дата:
Сообщение: Re: Permissons on database
Следующее
От: Richard Poole
Дата:
Сообщение: Re: Re: Use of the LIMIT clause ?