Dne 23. 11. 2016 v 14:08 Adriano dos Santos Fernandes napsal(a):
> On 23/11/2016 10:56, Alexandre Benson Smith wrote:
>> create view v as select a from t;
> When you use the base field directly, the view field uses the same domain.
>
> When you create an expression based on this field, the change to it does
> not reflect in the view.
>
> Because Firebird does not recompile dependent objects.
>
>
> Adriano
>

Another example - when the table field uses user defined domain, the 
same domain will be used by view.
When I alter the table field by changing it to use another wider domain, 
the view will retain the original narrow domain.

I.

------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to