Re: declarations of range-vs-element <@ and @>
Jeff Davis <pgsql@j-davis.com>
From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>, pgsql-hackers@postgreSQL.org
Date: 2011-11-17T18:18:47Z
Lists: pgsql-hackers
On Wed, 2011-11-16 at 16:41 -0500, Tom Lane wrote: > But what surprises me about this example is that I'd have expected the > heuristic "assume the unknown is of the same type as the other input" > to resolve it. Looking more closely, I see that we apply that heuristic > in such a way that it works only for exact operator matches, not for > matches requiring coercion (including polymorphic-type matches). This > seems a bit weird. I propose adding a step to func_select_candidate > that tries to resolve things that way, ie, if all the known-type inputs > have the same type, then try assuming that the unknown-type ones are of > that type, and see if that leads to a unique match. There actually is a > comment in there that claims we do that, but the code it's attached to > is really doing something else that involves preferred types within > type categories... > > Thoughts? That sounds reasonable to me. Regards, Jeff Davis