I want use CREATE TYPE to create one type similar to char. I want to when I create type, then my type behave similar to char:
CREATE TABLE test (oneChar char); when I want insert one column with length>1 to it, so it gets this error: ERROR: value too long for type character(1) I want my type behave similar this but it behaves similar varchar type.