Postgres Pro
Downloads
Home   >   mailing lists

Re: Correct syntax to create partial index on a boolean column - Mailing list pgsql-general

From Tom Lane
Subject Re: Correct syntax to create partial index on a boolean column
Date
Msg-id 5971.1323962894@sss.pgh.pa.us
Whole thread Raw
In response to Re: Correct syntax to create partial index on a boolean column  (Mike Christensen <mike@kitchenpc.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Server/Data Migration Advice
Next
From: Jay Levitt
Date:
Subject: Re: Correct syntax to create partial index on a boolean column