Re: [SQL] CHECK col A not NULL if col B='x'

[T E Schmitz]

Hola Martin!
Martin Marques wrote:
El Mar 28 Sep 2004 11:02, T E Schmitz escribió:
Is it possible to set up a table CHECK, which ensures that column A is
NOT NULL if column B = 'x' ?
CONSTRAINT somename CHECK (B <> 'x' OR A IS NOT NULL)
This is brilliant. Only detected this today. Don't know how I managed to 
overlook the CHECK constraints ;-)

--
Regards/Gruß,
Tarlika Elisabeth Schmitz
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])