How to send table to function as argument? [duplicate]
How to send a table to function as argument?
Need something like that:
CREATE OR REPLACE FUNCTION test(argTable TABLE(
field1开发者_开发知识库 integer,
field1 integer,
etc smallint
))
RETURNS integer AS
$BODY$
... Is it possible btw?
UPD: I'm going to send a temp table to function so I suppose I need table structure declaration in arguments list.
You could use EXECUTE
which allows the execution of an arbitrary string.
精彩评论