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

Reply via email to