04/09/25 03:12:19
>>657
CREATE OR REPLACE FUNCTION test_function(text) RETURNS INTEGER AS '
DECLARE
IN_table_name ALIAS FOR $1;
data_cnt INTEGER DEFAULT 0;
rec RECORD;
sql TEXT;
BEGIN
sql := ''SELECT * FROM ''||IN_table_name ;
FOR rec IN EXECUTE sql LOOP
data_cnt := data_cnt + 1;
END LOOP;
RETURN data_cnt;
END;
'
LANGUAGE 'plpgsql';