Re: table value function help

2018-11-22 Thread Glenn Schultz
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 wrote: > >> Hello, >>

Re: table value function help

2018-11-22 Thread David G. Johnston
On Thursday, November 22, 2018, Glenn Schultz 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 myfun

Re: table value function help

2018-11-22 Thread Adrian Klaver
On 11/22/18 8:25 AM, Glenn Schultz 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: I cannot follow what you are trying to achieve. create or replace function myfunction(sector, age

table value function help

2018-11-22 Thread Glenn Schultz
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$ sele