Re: function in place of sub-select - Mailing list pgsql-admin

From Bhuvan A
Subject Re: function in place of sub-select
Date
Msg-id Pine.LNX.4.44.0210161011030.1511-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to Re: function in place of sub-select  ("Mel Jamero" <mel@gmanmi.tv>)
List pgsql-admin
> One way might be to create a C (or C++) program that emulates your my_func
> function.
>
> We've tried doing this and did some benchmarks that show that the system
> works quite faster when you take out the stored procedures/functions and
> "translate" them into C programs.

Rightly said. C functions work faster than the stored procedures. But C
function too wont fit my case. The interpretation, to feed data to the IN
operator cannot be performed properly. How else do we achieve this?

regards,
bhuvaneswaran



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: newbie qs; fixing and checking databases
Next
From: Jyry Kuukkanen
Date:
Subject: Re: problems dumping