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

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