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.g.johns...@gmail.com> wrote: > On Thursday, November 22, 2018, Glenn Schultz <gl...@bondlab.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. >
