--- "Luiz K. Matsumura" <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
