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

From Gerald Cheves
Subject Re: [NOVICE] Boolean column in multicolumn index
Date
Msg-id c82b71a2-571d-f2ae-2f80-fb398f29ce04@verizon.net
Whole thread Raw
In response to Re: [NOVICE] Boolean column in multicolumn index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [NOVICE] Boolean column in multicolumn index  (Thomas Kellerer <spam_eater@gmx.net>)
List 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 is right in quotes but the other indices are not in quotes?

-- 
siamo arrivati sani e salvi

pgsql-novice by date:

Previous
From: Gerald Cheves
Date:
Subject: Re: [NOVICE] Boolean column in multicolumn index
Next
From: Thomas Kellerer
Date:
Subject: Re: [NOVICE] Boolean column in multicolumn index