Re: BUG #15055: parenthesis disappear

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #15055: parenthesis disappear
Дата
Msg-id CAKFQuwYAh5KAmA_25HQWZz6T=DLCKhTXaRWz_6m4-5DCpcerNg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15055: parenthesis disappear  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On Wed, Feb 7, 2018 at 9:04 AM, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15055
Logged by:          Andrei Mitran
Email address:      andrei@ivc.com
PostgreSQL version: 9.6.1
Operating system:   centos
Description:

alter table ivc.merit_matches
  add constraint priced_or_slotted_job
  check ((survey_code is null and slot_job_code is not null) or
         (slot_job_code is null and survey_code is not null));
results in:
Check constraints:
    "priced_or_slotted_job" CHECK (survey_code IS NULL AND slot_job_code IS
NOT NULL OR slot_job_code IS NULL AND survey_code IS NOT NULL)

What happened to my parens around the and conditions? I am not aware of any
precedence of and over or - Am i misinformed?


​Yes, see:​

​AND > OR

The system parses inputs and stores them in object form in the catalogs - then reconstructs a canonical representation when asked.

David J.

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #15053: SIGSEGV - While executing query with cube agregator
Следующее
От: David Kohn
Дата:
Сообщение: Re: BUG #15036: Un-killable queries Hanging in BgWorkerShutdown