create or replace function testQry()
returns setof record
language plpgsql
as $$
declare
i integer := 1;
rec record;
begin
while i <= 4
loop
if i%2=0 then
for rec in execute 'select '||i||' from table_'||lpad(i,4'0')||';'
loop
return next rec;
end loop;
else
for rec in execute 'select '||i||' from table_'||lpad(i,4'0')||';'
loop
return next rec;
end loop;
end if;
i := i+1;
end loop;
return;
end;
$$;
功能说明:
实现不同分表中查询数据并打印,并区分奇偶表(自行编写逻辑)