partial index

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: partial index
Date: 2001-08-06 01:27:59
Message-ID: 20010806102759W.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have created a test data using pgbench, played with the partial
index.

test=# create index myindex on accounts(aid) where bid <> 0;
CREATE
test=# explain select * from accounts where aid < 10 and bid <> 0;

and I got a log message:

DEBUG: clause_pred_clause_test: unknown pred_op

Is this normal?
--
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2001-08-06 01:45:14 Re: Possible solution for LIKE optimization
Previous Message Bruce Momjian 2001-08-06 01:16:32 Re: Idea for nested transactions / savepoints