Question : I’m trying to build a conditional check constraint for my table TBL_AFIL, which has two fields: Fec_Renun DATE […]
Tag: check-constraints
Postgres: How is SET NOT NULL “more efficient” than CHECK constraint
Question : In PostgreSQL docs for Constraints, it says A not-null constraint is functionally equivalent to creating a check constraint […]
“No Loop” Constraint for hierarchical data in postgresql
Question : I’ve got table like this in postgres: id primary key parent_id foreign key on id some data columns […]
Does any SQL engine have navigation support in CHECK clauses?
Question : Imagine a simple database to track personal spending. The most basic form of the model should let you […]
A table with all fields NULLable with important, sensitive data
Question : I have a requirement for a database table to hold sensitive patient information about their lifestyle (alcohol/ drug […]
Can I enforce one field being dependent on another?
Question : I would like to know if it’s possible to have two fields (in this case bits) in the […]
Add Constraint to check value exists in a non-unique composite key column
Question : I have the following table, which has a composite primary key: CREATE TABLE dbo.Seqs( SequenceKey nvarchar(10) NOT NULL, […]
CHECK constraint to limit certain rows
Question : I have the task to create an EAV table with some constraints. Attributes are foreign keys and some […]
PostgreSQL – Removing Unused Index on Check Constraint column
Question : I used the script from this blog to identify the unused index on my database. It returns an […]
Can I tell Postgres that a new constraint is valid without actually running the check?
Question : I have a constraint that ensures one of three columns is populated, and I’m adding a new column, […]