From: | Viswanatha Sastry <medipalli(at)yahoo(dot)com> |
---|---|
To: | Yambu <hyambu(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Re: function INPUT as whole table |
Date: | 2021-06-15 14:01:39 |
Message-ID: | 600227525.301090.1623765699598@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Yambu | 2021-06-15 14:07:17 | Re: function INPUT as whole table |
Previous Message | Tom Lane | 2021-06-15 13:33:28 | Re: function INPUT as whole table |