> On 05. Aug, 2020, at 20:30, Wells Oliver <wells.oliver@gmail.com> wrote: > > Err, sorry if this is back to basics, but I was very confused by someone being able to UPDATE myview SET col = 1 and the underlying table actually being updated properly. > > Is this recent? When did we become able to UPDATE on views?
yes, this is possible:
postgres=# create table t(i int); CREATE TABLE postgres=# create view v(i) as select i from t; CREATE VIEW postgres=# insert into v(i) values (0); INSERT 0 1 postgres=# select * from v; i --- 0 (1 row)
postgres=# update v set i=3; UPDATE 1 postgres=# select * from v; i --- 3 (1 row)
But I don't know since which PostgreSQL version views can up updated.