Re: its posible to use a 2 column returning function as a subquery?

Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> writes:
> There is some syntax for calling get_desc_and_price only once?

Do something like

select (t).* from (select get_desc_and_price(shoe) as t from ...) ss;

If you don't have get_desc_and_price marked as volatile, you'll probably
also need to add "offset 0" to the sub-select to keep the planner from
flattening the sub-select and producing multiple calls of the function.

regards, tom lane