Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux