Re: [HACKERS] SRF related and other questions

2004-11-21 Thread Katsaros Kwn/nos
On Sat, 2004-11-20 at 19:56, Joe Conway wrote: > When returning "setof record", the column definition must exist in the > query, and must match what ultimately is returned. This means that > whatever logic you use in your application to write the sql statement > must be able to derive the appro

Re: [HACKERS] SRF related and other questions

2004-11-20 Thread Joe Conway
Katsaros Kwn/nos wrote: Either set it to: "setof _some_predifined_type" or set it to: "setof records" and then define the expected results with "as(attr1 type, ..., attr_n type)". Right? Correct. Except it should be "setof record", not "setof records". If these are indeed the only ways, is it po