Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Support EXCLUDE constraints #3944

Open
ndeodhar opened this issue Mar 12, 2020 · 0 comments
Open

[YSQL] Support EXCLUDE constraints #3944

ndeodhar opened this issue Mar 12, 2020 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented Mar 12, 2020

Jira Link: DB-1497
Support EXCLUDE constraints on a table.

From postgres documentation (https://www.postgresql.org/docs/12/sql-createtable.html):
The EXCLUDE clause defines an exclusion constraint, which guarantees that if any two rows are compared on the specified column(s) or expression(s) using the specified operator(s), not all of these comparisons will return TRUE. If all of the specified operators test for equality, this is equivalent to a UNIQUE constraint, although an ordinary unique constraint will be faster. However, exclusion constraints can specify constraints that are more general than simple equality. For example, you can specify a constraint that no two rows in the table contain overlapping circles (see Section 8.8) by using the && operator.

@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label Mar 12, 2020
@ndeodhar ndeodhar self-assigned this Mar 12, 2020
@ndeodhar ndeodhar added this to To do in YSQL via automation Mar 12, 2020
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Aug 25, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Status: No status
YSQL
  
To do
Development

No branches or pull requests

2 participants