Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Achim Reiners — — source: Informix-list mailing list archive (1991-1998)
Hy Guys,
I have a problem that seems to be very simple but I think it is not.
I have a column that may contain NULL values but if there is a value different
from NULL this has to be unique. I.e. in other words no value except of NULL may
occur more than once.
Question: How do I explain this in INFORMIX by a constraint or by other means?
I would NOT prefer a trigger solution but declarative means, of course.
In practice, I think this is a very important issue. Very often you have columns
that have to be unique if the value is known but on the other hand it is possible
that the value is not known when the row is inserted.
Any ideas?
Achim
--
Achim Reiners
Schleupen Computersysteme GmbH & Co EDV fuer das Gesundheitswesen KG
Richard-Byrd-Str. 35 ** Tel.: (49) 221 - 956436-32
D-50829 Koeln ** EMail: ar@schleupen-gw-koeln.de
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.