Re: PostgreSQL 9.5 operator precedence
От | David G. Johnston |
---|---|
Тема | Re: PostgreSQL 9.5 operator precedence |
Дата | |
Msg-id | CAKFQuwbY1c1iUZGLzi5430tZN9==ozM7bh3uUXDfcbZ3KcRWew@mail.gmail.com обсуждение исходный текст |
Ответ на | PostgreSQL 9.5 operator precedence (Андрей Авакимов <aquarius1993@rambler.ru>) |
Ответы |
Re: PostgreSQL 9.5 operator precedence
|
Список | pgsql-sql |
Hello,
I've got a question about operator precedence is version 9.5
Versions lower than 9.5 worked well with constructions like
select a is null = b is null
(it calculates if a is null, then if b is null and then compare two booleans)
But now everything is changed, and official 9.5 documentations says that
IS operator has lower precedence than = operator
The thing I don't understand is the error message that I receive:
select 1 is null = 2 is null;
-----------------------------
ERROR: operator does not exist: boolean = integer
LINE 1: select 1 is null = 2 is null
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
В списке pgsql-sql по дате отправления: