On 3/31/16 12:19 PM, Alexander Ostrow wrote:

I thought it would be cool to have conditional check syntax, which gets
converted to simple check constraint syntax.

Here’s a gist:


It’s just sugar, but i think it would make check constraints easier to
read, and easier to write without backwards boolean logic.

Rather than this, I think an exclusive-or operator would be a lot more useful. The only difficulty I run into with CHECK constaints is when I want to ensure that only ONE condition is true.
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to