Hi,

Able to add below constraint check even after column student_name char size is 1.

ALTER TABLE public.student

add check ( student_name in ('Pune', 'Bombay', 'Delhi'));

I think it should not allow to add this constraint if we have the column char size is less than the size of values on which we are putting the constraints.

Thanks,

Kuldeep

Sent from Mail for Windows 10