Thomas Lockhart wrote: > ... > > "CREATE TABLE test (x int NULL)" doesn't look great either. :-) What > > is that NULL doing there? > > Well, because NOT NULL *was* in the standard, and because one should be > able to explicitly negate *that*. The alternative was > > CREATE TABLE test (x int NOT NOT NULL) > > :O
Yea, what I meant is that NULL doesn't look too clear in CREATE TABLE either. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html