Subject Re: [firebird-support] Cast as domain in view - wrong datatype
Author Dimitry Sibiryakov
24.08.2017 14:49, Jorge Andres Brugger jorge.brugger@... [firebird-support] wrote:
> View GTIN field is "exported" as varchar(20), instead of decimal(14,0).
> Am I doing domething wrong or could be a bug?

Because of your "else '' end as GTIN" server has no choice. Result of whole CASE
expression must be (var)char.


--
WBR, SD.