naman.iitb naman.b...@gmail.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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers