On Mon, Jan 29, 2018 at 6:42 AM, Garry Chen <gc92@cornell.edu> wrote:
Hi Andreas, Thank you very much for your reply. Very strange, in 9.6 the function created/compiled successful without the table called "acct_nbr_lst". But in release 10 this table "acct_nbr_lst" must exist in order to create/compiled this function. In RDBMS function/procedure coding principal, I don’t know which one is the correct way. Is there any Postgresql documents that states/mentation the prerequisite about the SETOF? Once again thank you very much for your help.
Anything outside of the string-literal function body (which includes the RETURNS clause) has to exist and is recorded as a dependency. The material within a function body usually (not sure if/when expections...) is not required to exist and is not recorded as a dependency.