Re: [Firebird-devel] Adding NOT NULL fields with DEFAULT

[Ann W. H. <aha...@ib...>]

Adriano dos Santos Fernandes wrote:
> 
> So I think on an alternate way. At field creation time, its default 
> value may be written in RDB$FORMATS. When reading a NOT NULL field
> with a DEFAULT, the value written in the format version of the
> record is returned. This may solve the problem of complex expressions,
> the problem of transaction visibility, and don't need an update on the
> whole table. I've no code to prove this, it's just an idea.
> 

How would you handle the case of a default of USER or CURRENT_TIME?


Cheers,

Ann