Re: Bug? 8.0 does not use partial index - Mailing list pgsql-hackers

Thanks, but the behaviour seems identical. :(

/Palle

--On fredag, januari 14, 2005 07.37.46 +1100 John Hansen 
<john@geeknet.com.au> wrote:

>> 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