Performance difference between sql and pgsql function... - Mailing list pgsql-performance

From Cristian Prieto
Subject Performance difference between sql and pgsql function...
Date
Msg-id 007401c5dfc2$9d2c41e0$6500a8c0@gt.ClickDiario.local
Whole thread Raw
List pgsql-performance
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?



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert performance for win32
Next
From: "Merlin Moncure"
Date:
Subject: Re: improvise callbacks in plpgsql