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