I have a function definited as such:
CREATE OR REPLACE FUNCTION address_pkg.parse_zip(IN cpostal character varying, OUT czip character varying, OUT czip4 character varying) LANGUAGE plpgsql;
How does one call this from another plpgsql function? Currently, I am using something of the form:
SELECT * INTO cZip, cZip4 FROM Address_pkg.Parse_Zip(postal_code);
But, I am not a big fan of this. Is there another way?