On Mon, Jul 25, 2005 at 08:28:32PM -0300, Martín Marqués wrote: > I tried adding this CONSTRAINT to the table definition, but with no luck: > > CONSTRAINT nonuloconfirmado CHECK > ((login NOT NULL AND password NOT NULL) OR NOT confirmado) > > It gives an error on the first NULL.
Use IS NOT NULL instead of NOT NULL. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
