Thanks, but the behaviour seems identical. :(
/Palle
--On fredag, januari 14, 2005 07.37.46 +1100 John Hansen <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
