Re: Boolean column in multicolumn index

From: Gerald Cheves <gcheves(at)verizon(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Boolean column in multicolumn index
Date: 2016-12-11 15:20:04
Message-ID: c82b71a2-571d-f2ae-2f80-fb398f29ce04@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.

I meant why isright in quotes but the other indices are not in quotes?

--
siamo arrivati sani e salvi

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2016-12-11 17:45:59 Re: Boolean column in multicolumn index
Previous Message Gerald Cheves 2016-12-11 10:05:53 Re: Boolean column in multicolumn index