Re: temporary table vs array performance

​I have no difficulty using arrays in functions.

As for "other methods" - you can use CTE (WITH) to create a truly local table - updating the catalogs by using a temp table is indeed quite expensive.

WITH vals AS  ( VALUES (1, 'lw'), (2, 'lw2') ) 

SELECT * FROM vals;

David J.