Hi All. My poor english doest not allow me to get a better subject. Here is the thing: I have a function who returns a two column result, that is is used inside another function, like this
CREATE FUNCTION show_result((some args), OUT shoe varchar, OUT desc varchar , OUT price numeric) ... as $$ select shoe, (get_desc_and_price(shoe)).desc, (get_desc_and_price(shoe)).price from ... $$ language sql; This is the only way i get this thing working. According to the timming, it looks like get_desc_and_price() is being called twice. There is some syntax for calling get_desc_and_price only once? As getting the 'description' and the 'price' share most of the logic, it looks ok to write a single function that does the job. Thanks! Gerardo -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
