Re: table value function help

Thanks!

I googled this for 3-days before coming here. I see what you mean. Thank
you so much will make the recommended changes.

Glenn

On Thu, Nov 22, 2018 at 11:02 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Thursday, November 22, 2018, Glenn Schultz <glenn(at)bondlab(dot)io> wrote:
>
>> 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)
>>
>
> Create function myfunction(arg1 text[], arg2 text[]) ...
>
> David J.
>
> p.s. You should avoid using the “char” data type in PostgreSQL, use text
> or varcar instead.
>