Richard Huxton <dev@archonet.com> writes: > Yann Michel wrote: >> I think you mean UNION ALL, i.e. the set addition, don't you?
> Not if you can identify the underlying table(s) and key(s). If the UNION > hides that information, then you are correct. If a unique key of the underlying table is included in the UNION data, then there can't be any duplicate rows and so the UNION really reduces to UNION ALL. However, I'm unconvinced that there are any cases like this that are interesting in practice. Consider CREATE TABLE a (id int primary key, ...); CREATE TABLE b (id int primary key, ...); CREATE VIEW v AS SELECT * FROM a UNION SELECT * FROM b; If a and b have disjoint key sets then the UNION is theoretically updatable, but there is no way to specify such a constraint and thus no way for the system to know that the UNION is updatable. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend