Re: [HACKERS] Bug? 8.0 does not use partial index

[John Hansen]

> 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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]