Re: Boolean column in multicolumn index

From: Gerald Cheves <gcheves(at)verizon(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Dima Pavlov <imyfess(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Boolean column in multicolumn index
Date: 2016-12-11 10:05:53
Message-ID: f955c2f2-609a-b6a4-8300-0ca0a3eada81@verizon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Gerald Cheves 2016-12-11 15:20:04 Re: Boolean column in multicolumn index
Previous Message Dima Pavlov 2016-12-11 06:13:21 Re: Boolean column in multicolumn index