"Ivan Prenosil" <Ivan.Prenosil@...> wrote:

>
> If you add *both* DEFAULT clause and NOT NULL constraint
> you will get what you need.

First, I wouldn't say this is exactly what he needs, because in fact records
will still contain NULLs in this column. Perhaps nobody would notice the
difference though.

Second, this hack may disappear in future versions (at least I always voted
for that).


Dmitry