Thanks for the help Pavel and Craig. I really appreciate it. I'm going to try a couple of these different options (write a c function, use a sql function with case statements, and use plperl), so I can see which gives me the realtime performance that I need, and works best for clean code in my particular case.
thanks! Anish On Wed, Aug 17, 2011 at 5:05 PM, Craig Ringer <ring...@ringerc.id.au> wrote: > 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 >
