plcontainer icon indicating copy to clipboard operation
plcontainer copied to clipboard

ERROR when process multiout_composite

Open BaiShaoqi opened this issue 6 years ago • 1 comments

Expected behavior

n | column2
---+---------
 2 | (4,6)
(1 row)

Actual behavior

 ERROR:  function multiout_composite(integer) does not exist
 LINE 1: SELECT * FROM multiout_composite(2);
                       ^
 HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Step to reproduce the behavior

CREATE FUNCTION multiout_composite(INOUT n integer, OUT type_record) AS $$
# container: plc_python_shared
return (n, (n * 2, n * 3))
$$ LANGUAGE plpythonu;

SELECT * FROM multiout_composite(2);

BaiShaoqi avatar Jun 01 '18 06:06 BaiShaoqi