[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: table value function help
From:       Glenn Schultz <glenn () bondlab ! io>
Date:       2018-11-22 18:43:28
Message-ID: CAE-4=KGbPqd-1yMRXm_BvjU-yFg3tXWxNsDMNguBWwOYXpcoZQ () mail ! gmail ! com
[Download RAW message or body]

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@gmail.com> wrote:

> 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.
>

[Attachment #3 (text/html)]

<div dir="ltr">Thanks!  <br><div><br></div><div>I googled this for 3-days before \
coming here.   I see what you mean.   Thank you so much will make the recommended \
changes.</div><div><br></div><div>Glenn</div></div><br><div class="gmail_quote"><div \
dir="ltr">On Thu, Nov 22, 2018 at 11:02 AM David G. Johnston &lt;<a \
href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">On Thursday, November 22, 2018, \
Glenn Schultz &lt;<a href="mailto:glenn@bondlab.io" \
target="_blank">glenn@bondlab.io</a>&gt; wrote:<br><blockquote class="gmail_quote" \
style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div \
dir="ltr"><div dir="ltr"><div dir="ltr">Hello,<div><br></div><div>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:</div><div>create or replace function \
myfunction(sector, agency, \
term)</div></div></div></div></blockquote><div><br></div><div>Create function \
myfunction(arg1 text[], arg2 text[]) ...</div><div><br></div><div>David \
J.</div><div><br></div><div>p.s. You should avoid using the "char" data type in \
PostgreSQL, use text or varcar instead.</div> </blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]