>You can try an index like:
>create index str_idx_url on str(url) where url >= ''; 
>
>I think that should be identical. ('' is the smallest string, no ?)

Thanks alot, it works now. But I still think the NOT NULL case would be
useful.

Best regards,
	Mario Weilguni

Wed, 13 Nov 2002 14:09:34 +0100
"Mario Weilguni" <mario.weilguni@icomedias.com>
Re: null values / partial indices