Обсуждение: Performance difference between sql and pgsql function...

Поиск
Список
Период
Сортировка

Performance difference between sql and pgsql function...

От
"Cristian Prieto"
Дата:
There any performance differences between a SQL function written in SQL
language or PL/psSQL language? For example:

Create or replace function sp_getfreq(
    Var1 integer
) returns Boolean as
$$
Declare
    Myval Boolean;
Begin
    Select var1 in (select var3 from table1) into myval;
    Return myval;
End;
$$
Language ‘plpgsql’ stable; 

And with:

Create or replace function sp_getfreq(
    Var1 integer
) returns boolean as
$$
Select $1 in (select var3 from table1);
$$
Language ‘sql’ stable;


I know the function is really simple, but in theory which of the three would
run faster?