partial index - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject partial index
Date
Msg-id 20010806102759W.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: partial index
List 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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Idea for nested transactions / savepoints
Next
From: Peter Eisentraut
Date:
Subject: Re: Possible solution for LIKE optimization