[Fwd: [Pgsql-ayuda] restricciones de dominio en tablas]

Hola:

Aqui tienes un ejemplo:

CREATE TABLE friend2 (
firstname CHAR(15),
lastname CHAR(20),
city CHAR(15),
state CHAR(2) CHECK (length(trim(state)) = 2),
age INTEGER CHECK (age = 2003),
gender CHAR(1) CHECK (gender IN ('M','F')),
last_met INTEGER CHECK (last_met BETWEEN 1 AND 100),
CHECK
(upper(trim(firstname)) != 'ED' OR

upper(trim(lastname)) != 'RIVERS')