Re: Cast on character columns in views

--- "Luiz K. Matsumura" <luiz@planit.com.br> wrote:
> CREATE VIEW view1( id, col1, type1, type2) AS
> SELECT table1.id,
>        table1.col1,
>        CAST( table2.type1 AS CHARACTER( 3 )),
>        NULL
> FROM   table1
> JOIN   table2 ON table2.fk_table1 = table1.id
> UNION ALL
> SELECT table1.id,
>        table1.col1,
>        CAST( NULL AS CHARACTER( 3 )),
>        table3.type2
> FROM   table1
> JOIN   table3 ON table3.fk_table1 = table1.id;

Would the above changes work?

Regards,
Richard Broersma Jr.