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 <mike@kitchenpc.com>)
Список pgsql-general
Mike Christensen <mike@kitchenpc.com> 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 по дате отправления: