Re: UPDATE works on a view?

Hi Oliver,

> On 05. Aug, 2020, at 20:30, Wells Oliver <wells(dot)oliver(at)gmail(dot)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.

Cheers,
Paul