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? |