From: | "Zeugswetter Andreas DCP SD" <ZeugswetterA(at)spardat(dot)at> |
---|---|
To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Implied Functional Index use |
Date: | 2006-07-13 10:49:22 |
Message-ID: | E1539E0ED7043848906A8FF995BDA579012B3EE1@m0143.s-mxs.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> There is a problem of implication here, AFAICS:
> When a user SQL asks
> WHERE col1 = 7
> which equality level is meant when several exist?
Well, the operator must be unique, so there is no problem.
Unique in the sense that an operator with the same name ('=' in this
case)
and argument types cannot exist for more than one level of equality.
(and the level should not have an effect on the resolution)
So, when we see col1 = 7 we lookup the equality level of the operator
and decide whether it is strict enough for the particular optimization.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2006-07-13 12:08:07 | Re: postgresql.conf basic analysis tool |
Previous Message | Tatsuo Ishii | 2006-07-13 09:02:34 | Re: Sun Donated a Sun Fire T2000 to the PostgreSQL |