Can I create a TYPE (or DOMAIN) with arguments?
| От | R.A. | 
|---|---|
| Тема | Can I create a TYPE (or DOMAIN) with arguments? | 
| Дата | |
| Msg-id | 1199872380.4784997c65ec5@mail.bluebottle.com обсуждение исходный текст  | 
		
| Ответы | 
                	
            		Re: Can I create a TYPE (or DOMAIN) with arguments?
            		
            		 Re: Can I create a TYPE (or DOMAIN) with arguments?  | 
		
| Список | pgsql-general | 
Hello,
I'm trying to create a composite type with an argument, to create one field of this type like character varying(x), but
Idon't know if this can be done with PostgreSQL. I want something like: 
CREATE TYPE mytype AS (
    tx       character varying(x),
    t2nd       integer
);
I need to limit the number of chars in this field tx. And different lengths will be used when creating tables with this
type(so a Domain will suffer the same problem). I'm not looking for a solution like a separate column with maxChars and
aCheck, because lots of columns will be required (and others design reasons). 
Any suggestions?
Thanks.
----------------------------------------------------------------------
Free pop3 email with a spam filter.
http://www.bluebottle.com/tag/5
		
	В списке pgsql-general по дате отправления: