CREATE OR REPLACE FUNCTION "common"."text1"("_i_table_name" text)
RETURNS "pg_catalog"."text" AS $BODY$
declare
_s_result TEXT;
_s_sql TEXT;
BEGIN
_s_sql := 'SELECT id from ' || _i_table_name || ' limit 1';
EXECUTE _s_sql into _s_result;
return _s_result;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
代码如上，动态传入表名称查询出数据
Processed:
0.010, SQL:
12
