Re: Domains and type coercion

From: Fernando Nasser <fnasser(at)redhat(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thomas Lockhart <thomas(at)fourpalms(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Domains and type coercion
Date: 2002-03-21 18:47:03
Message-ID: 3C9A2AA7.B0659415@redhat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-03-21 19:01:33 Re: Domains and type coercion
Previous Message Luis Amigo 2002-03-21 18:30:31 Re: Fw: Fw: bad performance on irix