AW: partial index - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject AW: partial index
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA41EB36D@m0114.s-mxs.net
Whole thread Raw
Responses Re: AW: partial index
List pgsql-hackers
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > test=# create index myindex on accounts(aid) where bid <> 0;

Hmm ? Am I reading correctly ? a restriction that is on a field, that 
is not in the index ? Does that make sense ? (aid --> bid)

> The original implementation would have refused to let you create a
> partial index with such a WHERE clause, since <> isn't a
btree-indexable
> operator.

But that is sad, since it would be a rather important use. Couldn't it
be 
rewritten to: (aid < 0 or aid > 0) ? (I assume you meant aid) 

Andreas


pgsql-hackers by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Possible solution for LIKE optimization
Next
From: Turbo Fredriksson
Date:
Subject: Re: PL/pgSQL: Return multiple rows