Re: [HACKERS] temporary table vs array performance

Its considered bad form to post to multiple lists. Please pick the most
relevant one - in this case I'd suggest -general.

On Mon, Sep 26, 2016 at 8:39 AM, dbyzaa(at)163(dot)com <dbyzaa(at)163(dot)com> wrote:

>
> Array is not convenient to use in function, whether
> there are other methods can be replaced temp table in function
>
>
​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.