On 10/29/2013 04:15 PM, naman.iitb wrote:
> So is there a way to populate manually IndexStmt-->whereClause
Unless you have an _extremely_ compelling reason, you should probably
just use the SPI routines to execute a CREATE INDEX command.
--
Craig Ringer http://www.2ndQuadrant
naman.iitb wrote:
> An example of partial index that i need is if my My table1 schema
> is (a int ,b int ,c int)
>
> index on c where a is null, b is null and c is not null
Your question is not very clear, but perhaps you are looking for
something like this:
CREATE INDEX index1 ON table1 (c)
Hello
I am doing a small project in Postgress where i have to achieve the
following:
Suppose i know the index name(lets say index1) and the relation(table1) on
which partial index to has to be build.
I was looking through the code and found that IndexStmt-->whereClause is the
one that i need to
