2008/10/24 Tom Lane <tgl@xxxxxxxxxxxxx>: > "Pavel Stehule" <pavel.stehule@xxxxxxxxx> writes: >> postgres=# create function simplefce(a int, b int) returns int as >> $$select $1 + $2$$ language sql immutable strict; >> CREATE FUNCTION >> postgres=# create function simplefce1(a int, b int) returns int as >> $$begin return a+b; end;$$ language plpgsql immutable strict; >> CREATE FUNCTION > > That's a pretty unfair comparison, because that SQL function is simple > enough to be inlined. The place to use plpgsql is when you need some > procedural logic; at which point a SQL function simply fails to provide > the required functionality. > Yes, this test is maximal unfair to plpgsql - it's too simply function. But it was original question. What is overhead plpgsql call on simple functions? On every little bit complicated functions overhead should be less. And this sample shows sense of using SQL functions. regards Pavel Stehule > regards, tom lane > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
