Re: BUG #13203: XOR Check looks missing parens in \d

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #13203: XOR Check looks missing parens in \d
Дата
Msg-id 38037.1430505751@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #13203: XOR Check looks missing parens in \d  (robertmassaioli@gmail.com)
Список pgsql-bugs
robertmassaioli@gmail.com writes:
> Now, the issue is that when you do \d and view the table that has been
> created the CHECK block is missing parens that show that it really will
> behave as an XOR. I think this is a bug that ould be great to fix. Please
> let me know if you need more information. Cheers!

It's not a bug that we print check constraints without unnecessary parens,
any more than it is that we don't reproduce whitespace exactly.

Those parens are unnecessary, because per the SQL standard AND binds more
tightly than OR.

            regards, tom lane

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

Предыдущее
От: robertmassaioli@gmail.com
Дата:
Сообщение: BUG #13203: XOR Check looks missing parens in \d
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)