Re: Domains and type coercion - Mailing list pgsql-hackers

From Fernando Nasser
Subject Re: Domains and type coercion
Date
Msg-id 3C9A2AA7.B0659415@redhat.com
Whole thread Raw
In response to Domains and type coercion  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Luis Amigo
Date:
Subject: Re: Fw: Fw: bad performance on irix
Next
From: "Rod Taylor"
Date:
Subject: Re: Domains and type coercion