Re: CREATE TYPE similar CHAR type

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: CREATE TYPE similar CHAR type
Дата
Msg-id CAA-aLv7EGhzdK=BnH7cUryKLBrKp3b3rYd-vC0S1hEyYc1gfpg@mail.gmail.com
обсуждение исходный текст
Ответ на CREATE TYPE similar CHAR type  (Mohsen SM <mohsensoodkhah@gmail.com>)
Список pgsql-hackers
On 6 March 2014 11:24, Mohsen SM <mohsensoodkhah@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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Mohsen SM
Дата:
Сообщение: CREATE TYPE similar CHAR type
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Next CommitFest Deadlines