Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Tatsuo Ishii
> The "setof" part is documented in src/backend/utils/fmgr/README. > There's no good documentation for returning tuples at the moment, > but basically you return a pointer to a TupleTableSlot. (Re-use > the same slot on each call to avoid memory leakage.) There's an > example in src/backend/exec

Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Joe Conway
Tatsuo Ishii wrote: > Does your SRF function allow to return a setof composite data type > using C function? If so, how can I write such that C function? I Just to follow-up, here's a quick look at what works and what doesn't, at least using my test script. SELECT * FROM myfunc(); Language Ret

Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Joe Conway
Tatsuo Ishii wrote: > Does your SRF function allow to return a setof composite data type > using C function? If so, how can I write such that C function? I > couldn't find any example or explanation so far. You referred dblink, > but in my understanding it does not have any function that returns a

Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Does your SRF function allow to return a setof composite data type > using C function? If so, how can I write such that C function? The "setof" part is documented in src/backend/utils/fmgr/README. There's no good documentation for returning tuples at the

Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Tatsuo Ishii
Does your SRF function allow to return a setof composite data type using C function? If so, how can I write such that C function? I couldn't find any example or explanation so far. You referred dblink, but in my understanding it does not have any function that returns a setof composite data type.

Re: [HACKERS] Set-returning function syntax

2002-05-18 Thread Joe Conway
Joel Burton wrote: > For those who want to play on the bleeding edge of CVS, can someone > provide the syntax for the recently-checked-in set-returning > functions? I've got it figured out when I'm returning a many rows of > single column, but not for many rows of several columns. For multipl

[HACKERS] Set-returning function syntax

2002-05-18 Thread Joel Burton
For those who want to play on the bleeding edge of CVS, can someone provide the syntax for the recently-checked-in set-returning functions? I've got it figured out when I'm returning a many rows of single column, but not for many rows of several columns. If someone can do this, and no one has p