create function test_empty_gen_rows
returns
    bigint
as
    declare variable n integer;
begin
    select
        n
      from
        gen_rows( null, null )
      into
        :n
    ;
    return row_count;
end

Result = 1