On 18/08/2011 3:00 AM, Anish Kejariwal wrote:
Thanks Pavel! that definitely solved it.
Unfortunately, the function I gave you was a simple/short version of
what the actual function is going to be. The actual function is going
to get parameters passed to it, and based on the parameters will go
through some if...else conditions, and maybe even call another
function. Based on that, I was definitely hoping to use plpgsql, and
the overhead is unfortunate.
Is there any way to get around this overhead? Will I still have the
same overhead if I use plperl, plpython, pljava, or write the function
in C?
You can probably still write it as an SQL function if you use CASE WHEN
appropriately.
--
Craig Ringer
