Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > Re: SRF in SFRM...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 6 Topic 9271 of 10122
Post > Topic >>

Re: SRF in SFRM_ValuePerCall mode

by dvnabble@[EMAIL PROTECTED] ("dv @[EMAIL PROTECTED] nabble") Apr 29, 2008 at 12:06 PM

OK,

Thank you for the explanation, I hope this will be implemented in future.
We will try and find a workaround to this issue until then.

Denis


----- Original Message ----- 
From: "Heikki Lin****angas" <heikki@[EMAIL PROTECTED]
>
To: "dv @[EMAIL PROTECTED]
 nabble" <dvnabble@[EMAIL PROTECTED]
>
Cc: "pgsql-hackers list" <pgsql-hackers@[EMAIL PROTECTED]
>
Sent: Monday, April 28, 2008 1:56 PM
Subject: Re: [HACKERS] SRF in SFRM_ValuePerCall mode


> dv @[EMAIL PROTECTED]
 nabble wrote:
>> I am working on implementation of custom "C" SRF for our team. The SRF
>> uses
>> SFRM_ValuePerCall mode. I know that sometimes even in SFRM_ValuePerCall
>> mode
>> all the rows returned from SRF are "materialized" (for performing
JOINs,
>> for
>> example).
>
> Yep, they are unfortunately always materialized. Back when set returning
> functions were implemented, the original patch did actually sup****t true
> "value per call" mode, where the whole result set was not materialized.
> However, it was dropped because of some issues I can't remember off the
> top of my head. The value-per-call API was committed, so that it was
> already in place when someone gets around to implement the backend
sup****t
> for it.
>
> However, no-one has bothered to do that to this date. Hannu Krosing
showed
> some interest in it recently, though:
> http://archives.postgresql.org/pgsql-hackers/2008-04/msg00345.php.
I
would
> love to see it happen.
>
> -- 
>   Heikki Lin****angas
>   EnterpriseDB   http://www.enterprisedb.com


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
 




 6 Posts in Topic:
SRF in SFRM_ValuePerCall mode
dvnabble@[EMAIL PROTECTED  2008-04-28 12:49:57 
Re: SRF in SFRM_ValuePerCall mode
heikki@[EMAIL PROTECTED]   2008-04-28 11:56:18 
Re: SRF in SFRM_ValuePerCall mode
tgl@[EMAIL PROTECTED] (T  2008-04-28 10:07:20 
Re: SRF in SFRM_ValuePerCall mode
dvnabble@[EMAIL PROTECTED  2008-04-29 12:40:53 
Re: SRF in SFRM_ValuePerCall mode
tgl@[EMAIL PROTECTED] (T  2008-04-29 10:22:34 
Re: SRF in SFRM_ValuePerCall mode
dvnabble@[EMAIL PROTECTED  2008-04-29 12:06:58 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Sep 7 13:28:51 CDT 2008.