create function get_id_name(begin_range int)
returns table(id int,name varchar(200))
language SQL
reads SQL DATA
return
select id ,name
from xxx
where id>begin_range;
运行的时候
select * from table(get_id_name(5)) c;
returns table(id int,name varchar(200))
language SQL
reads SQL DATA
return
select id ,name
from xxx
where id>begin_range;
运行的时候
select * from table(get_id_name(5)) c;