Hello, I have a table value function and would like the first and second input to take multiple arguments (array or list) I suppose. Like the below:
create or replace function myfunction(sector, agency, term) returns table (cusip char(9), sector char(12)) language sql stable as $function$ select foo from atable where sector in (myfunction.sector) usage sectorselect('sector_1 sector_2', 'agent_1 agent_2, 120)