Re: cursors and function question - Mailing list pgsql-general

On Feb 13, 2018, at 4:37 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

2) By global table do you mean a temporary table? If so not sure that is going to work as I am pretty sure it will disappear after the function is run.

​Temporary tables can survive until either session or transaction end - neither of which occurs automatically when exiting a function.

https://www.postgresql.org/docs/10/static/sql-createtable.html

"Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transaction (see ON COMMIT below)"

David J.