On 12/10/2016 7:04 PM, Tom Lane wrote:
CREATE INDEX "right" ON public.t USING btree (ci, cb, co);
CREATE INDEX wrong ON public.t USING btree (ci, co);
CREATE INDEX right_hack ON public.t USING btree (ci, (cb::integer), co);
The problem is that I can't force PostgreSQL to use the "right" index.
Why is only right in parenthesis but the other indices are not?
--
siamo arrivati sani e salvi