Re: returning parameters from function

Rikard Pavelic wrote:
> Martijn van Oosterhout wrote:
>> <snip>
>>
>> Just "setof record" will do. As for the implicit declaration of
>> variable names, that's harder. I don't know if you can do that without
>> making things very ambiguous.
>>
> I know setof record will do if I explicitly name OUT parameters.
> But I want Postgre to figure out for himself what parameters to return
> as out parameters.
>
> I don't see why it would make things very ambiguous.

Think about what happens if you use such a function in a join. How does
the planner know what to do? What about a prepared query?

--
   Richard Huxton
   Archonet Ltd