Re: returning parameters from function - Mailing list pgsql-general

From Richard Huxton
Subject Re: returning parameters from function
Date
Msg-id 457EBF0C.6030305@archonet.com
Whole thread Raw
In response to Re: returning parameters from function  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
Responses Re: returning parameters from function  (Rikard Pavelic <rikard.pavelic@zg.htnet.hr>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: returning parameters from function
Next
From: Florian Weimer
Date:
Subject: (Perl) script to set up an instance for regression tests