Re: [ADMIN] function in place of sub-select

2002-10-15 Thread Bhuvan A
> 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

Re: [ADMIN] function in place of sub-select

2002-10-14 Thread Mel Jamero
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

[ADMIN] function in place of sub-select

2002-10-12 Thread Bhuvan A
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