Re: [GENERAL] Returning large select results from stored procedures

2004-01-16 Thread Bill Moran
Richard Huxton wrote: On Thursday 15 January 2004 15:02, Bill Moran wrote: I'm having a little trouble understanding how to do something. I assume I'm just missing it in the documentation, so a pointer to relevent docs would be as welcome as a direct answer. I have a project in which I'll need to

Re: [GENERAL] Returning large select results from stored procedures

2004-01-15 Thread Richard Huxton
On Thursday 15 January 2004 15:02, Bill Moran wrote: > I'm having a little trouble understanding how to do something. I assume > I'm just missing it in the documentation, so a pointer to relevent docs > would be as welcome as a direct answer. > > I have a project in which I'll need to create a num

Re: [GENERAL] Returning large select results from stored procedures

2004-01-15 Thread Stephan Szabo
On Thu, 15 Jan 2004, Bill Moran wrote: > I'm having a little trouble understanding how to do something. I assume > I'm just missing it in the documentation, so a pointer to relevent docs > would be as welcome as a direct answer. > > I have a project in which I'll need to create a number of store

Re: [GENERAL] Returning large select results from stored procedures

2004-01-15 Thread Karsten Hilbert
> This query is going to return between 0 and n records, each with many > columns. I can't seem to grasp how to teach the procedure to return > an arbitrary number of rows with columns from the select statement. I think you need to read up on Set Returning Functions, or SRFs, which are quite new t