Re: [NOVICE] Boolean column in multicolumn index - Mailing list pgsql-novice

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