Search Postgresql Archives

Performance of pl/pgsql functions?

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

 



Do these tend to perform well? I have some simple formulas in functions like so:

CREATE OR REPLACE FUNCTION public.stat_foo(a integer, b integer, c integer)
  RETURNS numeric AS
$BODY$

declare ret numeric;

begin
select (a+b) / c::numeric into ret;
return round(ret, 3);
end

$BODY$
LANGUAGE plpgsql IMMUTABLE COST 100;

The reason I'm doing this is because i repeat this formula in a bunch of views and queries, and it's easier to have one function. Would this somehow be slower than reproducing the formula in every view its used? I'm hoping not...

--
Wells Oliver
wellsoliver@xxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux