Performance difference between sql and pgsql function...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux