Re: function INPUT as whole table

ok, thank you all

On Tue, Jun 15, 2021 at 4:01 PM Viswanatha Sastry <medipalli(at)yahoo(dot)com>
wrote:

> You can send it as a json object from App. in PostgreSQL it will be
> string datatype as parameter and you can insert into a temp table with json
> function.
>
> Thanks & Regards
> Viswanatha Shastry M.
> Hyderabad,
> Phone Mobile : 9493050037
>
>
> On Tuesday, 15 June, 2021, 06:11:20 pm IST, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>
>
> On Tuesday, June 15, 2021, Yambu <hyambu(at)gmail(dot)com> wrote:
>
> Hello
>
> Is it possible to have as input to a function , a whole table contents,
> if the table is a small lookup table?
>
> Something like this
>
> CREATE or replace function test (IN (select * from table1) )
>
>
> No. Function arguments are data types, not contents. Queries go inside
> the function body.
>
> David J.
>
>
>