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: [email protected] web: http://therp.nl _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
