Re: Domains and type coercion

Tom Lane wrote:
> 
> If we take the hard SQL99 line that domains *are* the base type plus
> constraints, then we could reduce domains to base types before we start
> the entire matching process, and this issue would go away.  This would
> prevent declaring any specialized operators or functions for a domain.
> (In fact, I'd be inclined to set things up so that it's impossible to
> store domain type OIDs in pg_proc or pg_operator, thus saving the time
> of doing getBaseType on one side of the match.)  Thoughts?
> 

IMHO this is the right thing to do.

-- 
Fernando Nasser
Red Hat - Toronto                       E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9