openerp-community team mailing list archive

[Holger Brunn <hbrunn@xxxxxxxx>]

Hallo Martin,

> I want NULL integers so I can have a unique constraint on the ones that
> exist
> and not care about the ones that don't.
> What ugly hack am I going to have to employ to achieve this now?

use a partial unique index: 
http://www.postgresql.org/docs/9.1/interactive/indexes-partial.html

Not an ugly hack, but should suit your needs. 

-- 
Therp - Maatwerk in open ontwikkeling

Holger Brunn - Ontwerp en implementatie

mail: holger@xxxxxxxx
web: http://therp.nl