Re: Order of precedence between AND and OR.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Order of precedence between AND and OR.
Дата
Msg-id 26190.1132948743@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Order of precedence between AND and OR.  (David Pradier <david.pradier@clarisys.fr>)
Список pgsql-sql
David Pradier <david.pradier@clarisys.fr> writes:
> But what I couldn't find is if there is an order of precedence between
> AND and OR, that is if the AND expression is calculated before the OR
> one, or anyelse way.

AND first; see
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-PRECEDENCE
This is required by the SQL spec.

But you probably also want to read
http://www.postgresql.org/docs/8.1/static/sql-expressions.html#SYNTAX-EXPRESS-EVAL
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: David Pradier
Дата:
Сообщение: Order of precedence between AND and OR.
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: sysid