Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> However, that's not quite the end of it -- preprocess_function_rtes()
> / inline_set_returning_function() can turn a function RTE into a
> subquery RTE, leading to a similar problem:
> create table foo (a int, b int);
> insert into foo values (1,2);
> create or replace function f() returns setof foo as
> $$ select * from foo offset 0 $$ language sql stable;
> update foo set b = f.b from f() as f(a,b) where f.a = foo.a returning f;
> ERROR: attribute 3 of type record has wrong type
> DETAIL: Table has type record, but query expects foo.
Double ugh. I guess we could get preprocess_function_rtes to
insert the appropriate relid ...
regards, tom lane
