Marius Lorek writes:
> If I have a table
> create table my_table(id int primary key);
> and a function
> create function my_function() returns table(id int) stable as $$ select *
> from my_table $$ language sql;
> then Postgres knows that selecting from the function is really just
> selecting
Hi All,
If I have a table
create table my_table(id int primary key);
and a function
create function my_function() returns table(id int) stable as $$ select *
from my_table $$ language sql;
then Postgres knows that selecting from the function is really just
selecting from the table:
explain se
