On 6 March 2014 11:24, Mohsen SM <mohsensoodk...@gmail.com> wrote: > 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. > > If you did that, you'd have a char field padded out to fill up 10 megabytes-worth of characters. I doubt that's what you want.
It's not clear what you want this for though. If you want an arbitrary number of characters, just use the text data type. -- Thom