Skip site navigation (1) Skip section navigation (2)

Re: Bug? 8.0 does not use partial index

From: "John Hansen" <john(at)geeknet(dot)com(dot)au>
To: "Palle Girgensohn" <girgen(at)pingpong(dot)net>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug? 8.0 does not use partial index
Date: 2005-01-13 20:37:46
Message-ID: 5066E5A966339E42AA04BA10BA706AE5622F@rodrick.geeknet.com.au (view raw or flat)
Thread:
Lists: pgsql-hackers
> create index foo on group_data(this_group_id) where group_id is null;

Try this instead;

create index foo on group_data(this_group_id) where nullvalue(group_id);

And 

Select * from group_data where this_group_id = 46 and nullvalue(group_id);

... John

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-01-13 21:25:58
Subject: Re: some linker troubles with rc5 on sun studio 9 ...
Previous:From: Brad NicholsonDate: 2005-01-13 20:05:18
Subject: Port Report: Linux SuSE Enterprise Server 9 (x86_64)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group