Re: Domains as Subtypes

On Mon, Mar 27, 2006 at 11:41:30AM -0500, Tom Lane wrote:
> elein <elein@varlena.com> writes:
> > But I like the idea of centralizing the check in the input/output
> > functions.  It seems clearer and cleaner.
> 
> I remembered the problem with doing it that way: an input function can't
> enforce a domain NOTNULL constraint, because it won't even get invoked
> for a null input value.  So there seems no way around having a special
> case for domains in all places where I/O conversion is done.
> 

The notnull attribute of the pg_type table should be set to not null
in the case of a not null constraint on a domain (type).
You should not have to invoke the input function to check for that.  
Or perhaps I'm missing the details.

>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 

elein
elein@varlena.com