Postgresql and inline functions

Question

How can i declare non-inline function in postgresql? Only with adding 'out' argument?
Is table functions(returns table) inline?

Post code of what you're trying

OMG Ponies
– OMG Ponies

2012-02-19 03:50:46 +00:00
Commented Feb 19, 2012 at 3:50 — OMG Ponies
– OMG Ponies, Commented Feb 19, 2012 at 3:50

A.H. · Accepted Answer · 2012-02-19 21:05:25Z

1

Inlining is always an optimization¹ - this means that "the system" will perform inlining only when it is sure that the result is just the same as without inlining.

So: If you ask "how can I prevent inlining" you should better ask "What I'm doing wrong or why behaves "the system" wrong?" and solve that problem.

¹ Whether a successfull optimizazion or not is not the question here.

answered Feb 19, 2012 at 21:05

A.H.

66.8k16 gold badges97 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nyaapa Over a year ago

Ok, can this function can be inlined? create function Tabli() returns table(Type character varying(15), Cost bigint) AS $$ begin return query select "Type", sum("Cost") from "tblProject" group by "Type"; end; $$ language plpgsql;

nyaapa Over a year ago

Thank for your answer, i have read documentation one more time and understand inline oprimization.

Collectives™ on Stack Overflow

Postgresql and inline functions

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related