Re: Creating partial index on a relation

naman.iitb <naman(dot)bbps(at)gmail(dot)com> 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)
  WHERE a IS NULL AND b IS NULL AND c IS NOT NULL;

This list is for discussion of adding features and fixing bugs in
the the PostgreSQL product.  For future posts requesting help with
*using* PostgreSQL please use the pgsql-general list.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company