From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: CREATE TYPE similar CHAR type |
Date: | 2014-03-06 16:39:13 |
Message-ID: | 1394123953858-5794981.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
mohsencs 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 can get over the need for using CREATE TYPE you'll find that using
CREATE DOMAIN with a check constraint will probably meet your needs
perfectly.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/CREATE-TYPE-similar-CHAR-type-tp5794946p5794981.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-03-06 17:28:35 | Re: jsonb and nested hstore |
Previous Message | Andrew Dunstan | 2014-03-06 16:09:12 | Re: jsonb and nested hstore |