Re: table value function help - Mailing list pgsql-general

From David G. Johnston
Subject Re: table value function help
Date
Msg-id CAKFQuwavpGYpRRoj3sEG7fzU-isQ+WuJwnVYjquxt5biwb_5yA@mail.gmail.com
Whole thread Raw
In response to table value function help  (Glenn Schultz <glenn@bondlab.io>)
Responses Re: table value function help
List pgsql-general
On Thursday, November 22, 2018, Glenn Schultz <glenn@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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: table value function help
Next
From: Glenn Schultz
Date:
Subject: Re: table value function help