Re: syntax error on Function return setoff
| От | David G. Johnston |
|---|---|
| Тема | Re: syntax error on Function return setoff |
| Дата | |
| Msg-id | CAKFQuwZRtJj4PdrGfSXJ2ZQQQHyh8hnpuVA_NJ-tZ6+hLXMqNw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: syntax error on Function return setoff (Garry Chen <gc92@cornell.edu>) |
| Список | pgsql-novice |
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.
David J.
В списке pgsql-novice по дате отправления: