Hi,
My quick $0.02 worth...
:
: I guess the main question is, will we allow the serial type to be NULL.
: If not will we allow the NOT NULL phrase anyway to simplify the grammar.
: If yes to either then let's allow the phrase now.
:
I don't see how you can allow a serial value to be null, since that
would defeat the purpose of a serial (presuming there were more than one
NULL-valued serial in a table). I just don't see how, logically, a serial
could allow NULLs (even if it may be desirable in some cases).
On the other hand, I would allow the NOT NULL phrase, even though
it's redundant.
Brendan
--
Brendan McKenna
Technical Director Phone: +353-(0)61-338177 x4143
W3 Services Ltd. Fax: +353-(0)61-338065
Innovation Centre Email: brendan@w3s.ie
National Technological Park
Limerick
Ireland