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.johnston@xxxxxxxxx> wrote:
On Thursday, November 22, 2018, Glenn Schultz <glenn@xxxxxxxxxx> 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.
