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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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