Postgres Pro
Downloads
Home   >   mailing lists

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

From Albe Laurenz
Subject Re: Correct syntax to create partial index on a boolean column
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2073C8D1F@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Correct syntax to create partial index on a boolean column  (Mike Christensen <mike@kitchenpc.com>)
List pgsql-general
Tree view 
Mike Christensen wrote:
> For the boolean column Foo in Table1, if I want to index all values of
> TRUE, is this syntax correct?
>
> CREATE INDEX IDX_MyIndex ON Table1(Foo) WHERE Foo;

Yes, that is correct.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Locking Tables & Backup Inquiry
Next
From: Bèrto ëd Sèra
Date:
Subject: Re: Philosophical question