Re: Type modifiers for DOMAIN

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Cc: pgsql-hackers@postgresql.org
Date: 2010-01-06T17:54:58Z
Lists: pgsql-hackers
>     /* Domains never accept typmods, so no typmodin/typmodout needed */
> but can we relax the restriction? This feature would be useful for migration
> from other DBMSes that have non-standard data types.

For migration, wouldn't it be adequate simply to ignore the typemod?  Or
to allow it as part of the type name? e.g.:

create domain "varchar2(10)" AS varchar
	check ( length(value) <= 10 );

I know that wouldn't actually work, but you see what I'm getting at?

--Josh Berkus