postgres array 循环
DO $$DECLAREname_iter integer;BEGINFOREACH name_iter inARRAY ARRAY[1,2,3] LOOPRAISE NOTICE 'name %', name_iter;END LOOP;END;$$ LANGUAGE plpgsql;
·
DO $$
DECLARE
name_iter integer;
BEGIN
FOREACH name_iter in ARRAY ARRAY[1,2,3] LOOP
RAISE NOTICE 'name %', name_iter;
END LOOP;
END;
$$ LANGUAGE plpgsql;
更多推荐
已为社区贡献1条内容
所有评论(0)