I searched the internet for 2 days to find the answer and couldn’t. Basically I have this as a problem : "The login is composed of the first letter of the first name and the first 7 letters of the name (in lowercase) followed by two numbers." My problem relies in the last 4 words… Read More How to write a check constraint to verify if login is correct or not?

I would like to define a Postgres domain with check constraints based on a custom composite type. An example for a naive approach would be this: CREATE TYPE raw_comp_foo AS ( min_value integer, max_value integer ); CREATE DOMAIN comp_foo AS raw_comp_foo CHECK (VALUE.min_value < VALUE.max_value); However, I get the error message missing FROM-clause entry for… Read More How to define CHECK constraint for a Postgres DOMAIN that is based on a composite type

I’m using SQL Server and am trying to add a column and a check constraint. I’ve found that the following works: ALTER TABLE table.column ADD isTrue BIT GO ALTER TABLE table.column ADD CONSTRAINT CK_table_isTrue CHECK ((isTrue = 1 AND column1 = 0 AND column2 = 0 AND column3 IS NULL) OR isTrue = 0) However… Read More Why can't I add a column to an existing table with a checkConstraint that references other columns in SQL