[SQL] Unable to use INSERT ... RETURNING with column from other table - Mailing list pgsql-sql

create table foo(   id integer PRIMARY KEY,   name varchar not null
);

insert into foo(id, name) values(1, 'one'), (2, 'two');

insert into foo(id, name) select 3, f.name from foo f where f.id = 1 returning id, f.id;

ERROR:  missing FROM-clause entry for table "f" 
LINE 1: ...lect 3, f.name from foo f where f.id = 1 returning id, f.id;