FOR循环查询结果teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END; teledb
FOR循环查询结果teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END; teledb
FOR循环查询结果 teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END;
FOR循环查询结果teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END; teledb
FOR循环查询结果teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END; teledb
FOR循环查询结果teledb=# CREATE OR REPLACE FUNCTION f27() RETURNS VOID AS teledb-# $$ teledb$# DECLARE teledb$# v_rec RECORD; teledb$# BEGIN teledb$# FOR v_rec IN SELECT * FROM public.t LOOP teledb$# RAISE NOTICE '%',v_rec; teledb$# END LOOP; teledb$# END; teledb