Thread: Views created by UNION ALL

Views created by UNION ALL could be updated with both UPDATE and
DELETE operations. They are just transformed to UPDATE/DELETE
operation on base tables (or views). I think INSERT cannot be accepted
however.  For example, suppose we have v1:

CREATE VIEW v1 AS SELECT * FROM t1 UNION ALL SELECT * FROM t2;

Inserting into v1 is ambiguous because it can be transformed either
inserting into t1 or t2.

So I think we could make v1 auto updatable view.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp