Re: SRF in C - Mailing list pgsql-general

From Bruce Momjian
Subject Re: SRF in C
Date
Msg-id 200401162050.i0GKowT02433@candle.pha.pa.us
Whole thread Raw
In response to SRF in C  (Jeff Davis <jdavis-pgsql@empires.org>)
Responses Re: SRF in C
List pgsql-general
Jeff Davis wrote:
> in section _37.7.1.2. RETURN NEXT_ of the docs, it says that "PL/pgSQL
> stores the entire result set before returning from the function".
>
> Is the same true for C, and if so, should we document it in
> _33.7.9. Returning Sets from C-Language Functions_ ?
>
> It could be important if someone wanted to return a huge amount of data
> from an SRF and it was larger than available RAM.

I would assume the C function guys would know this was obvious.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Josh Berkus
Date:
Subject: Potential Problem with PostgeSQL performance on SuSE Linux 9.0
Next
From: "Chris Ochs"
Date:
Subject: Re: User-specific sequences