Gerardo Herzig <[email protected]> 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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
