Problem with the semantics of "select into" in a plpgsql function

Поиск
Список
Период
Сортировка
Greetings,
I have a plpython function that returns a set of records. I loop over them to insert them into a temp table created by another function.
I wanted to test
select into temp_eav_table (column) select a.column from tbl as a where....
approach to see if it performs better than the loop. However, I'm not able to compile the function due to an error that says "temp_eav_table is not a known variable"

So the context assumes this is supposed to be a variable. If I try execute '...', then I have trouble passing a bytea parameter to the python function. This is what I have at the moment:

SELECT INTO temp_eav_table (valstring,
                                    featuremappingid,
                                    featurename,
                                    rmtypename,
                                    actualrmtypename,
                                    path,
                                    pathstring)
    select selected_node.valstring,
                                    selected_node.featuremappingid,
                                    selected_node.featurename,
                                    selected_node.rmtypename,
                                    selected_node.actualrmtypename,
                                    selected_node.path,
                                    selected_node.pathstring
    from py_get_eav_rows_from_pb(payload ) as selected_node;

any thoughts?

Best regards
Seref

В списке pgsql-general по дате отправления:

Предыдущее
От: Philipp Kraus
Дата:
Сообщение: dataset user access
Следующее
От: David Johnston
Дата:
Сообщение: Re: Problem with the semantics of "select into" in a plpgsql function