Skip site navigation (1) Skip section navigation (2)

Re: inheritance, and plans

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: inheritance, and plans
Date: 2009-02-08 18:34:05
Message-ID: 23440.1234118045@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
> Type-dependent selection of operators has already been done as part of
> parse analysis, no? And the domain -> base conversion is purely a
> relabelling, no? So what semantic change is possible as a result?

Domain conversions are *not* simply relabellings.  It's possible now to
have domain-specific functions/operators, and the likely future
evolution of the system is to make that work better rather than remove it.

It's possible that there are specific cases where the UNION optimization
checks could allow domains to be treated as their base types, but
blindly smashing both sides of the check to base is going to break more
cases than it fixes.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Andrew GierthDate: 2009-02-08 18:58:51
Subject: Re: inheritance, and plans
Previous:From: Andrew GierthDate: 2009-02-07 17:58:56
Subject: Re: inheritance, and plans

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group