> 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 fun
Regards,
Mel Jamero
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bhuvan A
Sent: Saturday, October 12, 2002 7:52 PM
To: [EMAIL PROTECTED]
Subject: [ADMIN] function in place of sub-select
Hi,
I am using postgresql 7.2 on RHL7.3.
I know that we cannot
Hi,
I am using postgresql 7.2 on RHL7.3.
I know that we cannot return a record or multiple values from a plpgsql
procedure unless otherwise it is a triggered procedure. But i have a need
to use a function in place of sub-select, something like
select * from my_table where field1 in (select my_fu