Subject Re: Default Value not working
Author Svein Erling
--- In, Geoff Worboys wrote:
> I think that a neat solution could be for SQL to support a
> "FORCED DEFAULT ..." syntax (ie; just extend the existing
> syntax). For maximum convenience it would good is such syntax
> caused two actions during insert and update...
> I would be interested to hear if there were others interested
> in such a concept (or perhaps others that think it is may be
> a terrible idea). If there was interest then I could put the
> idea to developers to see if...
> - it was practical
> and
> - it was desirable.

I do not need anything like this, but I think that FORCED DEFAULT
sounds a bit limiting if anything like this should be implemented.
Rather, I would suggest DEFAULT ... WHEN ... END. This way, the
default could be set to override various states and values.