Re: Correct syntax to create partial index on a boolean column

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Correct syntax to create partial index on a boolean column
Дата
Msg-id
5971.1323962894@sss.pgh.pa.us
Ответ на
Re: Correct syntax to create partial index on a boolean column (Mike Christensen)
Список
Дерево обсуждения
Correct syntax to create partial index on a boolean column Mike Christensen <mike@kitchenpc.com>
Re: Correct syntax to create partial index on a boolean column Alban Hertroys <haramrae@gmail.com>
Re: Correct syntax to create partial index on a boolean column Craig Ringer <ringerc@ringerc.id.au>
Re: Correct syntax to create partial index on a boolean column Jay Levitt <jay.levitt@gmail.com>
Re: Correct syntax to create partial index on a boolean column Mike Christensen <mike@kitchenpc.com>
Re: Correct syntax to create partial index on a boolean column Tom Lane <tgl@sss.pgh.pa.us>
Re: Correct syntax to create partial index on a boolean column Mike Christensen <mike@kitchenpc.com>
Re: Correct syntax to create partial index on a boolean column Mike Christensen <mike@kitchenpc.com>
Re: Correct syntax to create partial index on a boolean column "Albe Laurenz" <laurenz.albe@wien.gv.at> 
Mike Christensen  writes:
> BTW, this table (RecipeMetadata) will only ever be used in a join.  I
> will never query it directly.  But I'll query Recipes and join in
> RecipeMetadata.

In that case possibly you want the join key to be the index payload.

			regards, tom lane
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: Jay Levitt
Дата:
FAQ