Re: syntax sugar for conditional check - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: syntax sugar for conditional check
Date
Msg-id CAKFQuwZ30Pk0OCeW3qv7DttXfc1nnRCq+Roci=ckXHip20W_Ng@mail.gmail.com
Whole thread Raw
In response to syntax sugar for conditional check  (Alexander Ostrow <aj@epcylon.com>)
Responses Re: syntax sugar for conditional check
List pgsql-hackers
On Thu, Mar 31, 2016 at 10:19 AM, Alexander Ostrow <aj@epcylon.com> wrote:
Hello,

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. 

For future reference please make every effort to make emails to the list self-contained - which has the added benefit of avoid link expiration in the future.

As to the recommendation at hand - I don't see significant value in implementing non-SQL Standard syntax in this area.

David J.
​​

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance improvement for joins where outer side is unique
Next
From: Alvaro Herrera
Date:
Subject: Re: [COMMITTERS] pgsql: Improve internationalization of messages involving type names