UDTF

示例

1. 创建UDTF：

   CREATE FUNCTION py_generate_series(start int, endnum int, step int)
   RETURNS TABLE(a int)
   LANGUAGE python
   RUNTIME_VERSION='3.11.2'
   HANDLER='generate_series'
   as $$
   def generate_series(start, endnum, step):
       current = start
       while current <= endnum:
           yield current
           current += step
   $$;

2. 执行UDTF：

   SELECT py_generate_series(1,4,1);
    py_generate_series 
   ----------------------
                       1
                       2
                       3
                       4
   (4 rows)