On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote: > But "not null" is in contradiction with "default null" so the create > statement should not proceed successfuly IMHO.
The fact that the default value isn't going to pass a constraint means that it's invalid to not provide a value or use default, yes, but I don't agree that it's necessarily a real contradiction in the definition, especially given that AFAIK there's no way to opt out of having a default (apart from a construct like the one given). ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly