Problem with the semantics of "select into" in a plpgsql function
От | Seref Arikan |
---|---|
Тема | Problem with the semantics of "select into" in a plpgsql function |
Дата | |
Msg-id | CA+4Thdr6od2JGXELyuC1gEQ911O2D+q6VSm_okXbdvg5KG84=Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Problem with the semantics of "select into" in a plpgsql function
Re: Problem with the semantics of "select into" in a plpgsql function Re: Problem with the semantics of "select into" in a plpgsql function |
Список | pgsql-general |
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
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 по дате отправления: