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.

Reply via email to