Unique and nulls ?

[Bart Pietercil]

Thank you, just what I needed :-)

May I suggest to include this information with fNullable or fUnique  
in the WIKI page
<http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vkernel:vfield:flags&s=unique>

Bart
On 4-okt-07, at 11:37, Ruslan Zasukhin wrote:

> On 4/10/07 11:43 AM, "Bart Pietercil" <bart.pietercil at gmail.com>  
> wrote:
>
>> Hi List,
>>
>> is it possible to combine for a given field the nullable and unique
>> properties in such a way that the null values are excluded from the
>> unique test ?
>>
>> Case: field mailaddress
>> This field should be unique but I do not always have a mailaddress so
>> it needs to accept null values. These null values should be excluded
>> from the unique test.
>
> YES,
>
> UNIQUE field still can be NULLable.