> On Feb 13, 2018, at 4:37 PM, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Tue, Feb 13, 2018 at 3:31 PM, Adrian Klaver <adrian.kla...@aklaver.com > <mailto:adrian.kla...@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 > <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. >
Thank you both of you Adrian and David for the input and help I owe you some nice red wine :) Cheers - Armand
