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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: robertmassaioli(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13203: XOR Check looks missing parens in \d
Date: 2015-05-01 18:42:31
Message-ID: 38037.1430505751@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

robertmassaioli(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2015-05-01 19:08:39 Re: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Previous Message Tom Lane 2015-05-01 17:08:54 Re: Failure to coerce unknown type to specific type