Date: Tue, 15 Jun 2021 14:01:39 +0000 (UTC)
From: Viswanatha Sastry <medipalli@yahoo.com>
Reply-To: Viswanatha Sastry <medipalli@yahoo.com>
To: Yambu <hyambu@gmail.com>,
	"David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Message-ID: <600227525.301090.1623765699598@mail.yahoo.com>
In-Reply-To: 
 <CAKFQuwZHBrbS89GJhZnaUjPLtYcOLkiiRSBYo=MD0uMEdJYMhw@mail.gmail.com>
References: 
 <CALhHtcAGqGgCDKYg5rgwxqjXDhJnAH+qYxFDAya2Jn4CWxSV1A@mail.gmail.com>
 <CAKFQuwZHBrbS89GJhZnaUjPLtYcOLkiiRSBYo=MD0uMEdJYMhw@mail.gmail.com>
Subject: Re: function INPUT as whole table
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_301089_873857642.1623765699597"
Content-Length: 3397
Archived-At: 
 <https://www.postgresql.org/message-id/600227525.301090.1623765699598%40mail.yahoo.com>
Precedence: bulk

------=_Part_301089_873857642.1623765699597
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

You can send it as a json object from App. in PostgreSQL=C2=A0 it will be s=
tring datatype as parameter and you can insert into a temp table with json =
function.
Thanks & Regards=C2=A0Viswanatha Shastry M.=C2=A0Hyderabad,=C2=A0Phone Mobi=
le : 9493050037=20

    On Tuesday, 15 June, 2021, 06:11:20 pm IST, David G. Johnston <david.g.=
johnston@gmail.com> wrote: =20
=20
=20
On Tuesday, June 15, 2021, Yambu <hyambu@gmail.com> wrote:

Hello

Is it possible to have as input to a function , a whole table contents,=C2=
=A0 if the table is a small lookup table?
Something like this=C2=A0 =C2=A0=C2=A0=C2=A0
CREATE or replace function test (IN (select * from table1) )=C2=A0=20

No.=C2=A0 Function arguments are data types, not contents.=C2=A0 Queries go=
 inside the function body.
David J.=C2=A0=C2=A0 =20
------=_Part_301089_873857642.1623765699597
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"ydpbf26b1a6yahoo-style-wrap" style=
=3D"font-family:times new roman, new york, times, serif;font-size:16px;"><d=
iv><div dir=3D"ltr" data-setdir=3D"false">You can send it as a json object =
from App. in PostgreSQL&nbsp; it will be string datatype as parameter and y=
ou can insert into a temp table with json function.</div><div><br></div><di=
v class=3D"ydpbf26b1a6signature">Thanks &amp; Regards&nbsp;<div>Viswanatha =
Shastry M.&nbsp;</div><div>Hyderabad,&nbsp;</div><div>Phone  Mobile : 94930=
50037</div></div></div>
        <div><br></div><div><br></div>
       =20
        </div><div id=3D"yahoo_quoted_4562030171" class=3D"yahoo_quoted">
            <div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
               =20
                <div>
                    On Tuesday, 15 June, 2021, 06:11:20 pm IST, David G. Jo=
hnston &lt;david.g.johnston@gmail.com&gt; wrote:
                </div>
                <div><br></div>
                <div><br></div>
                <div><div id=3D"yiv4584774629"><div><br clear=3D"none">On T=
uesday, June 15, 2021, Yambu &lt;<a rel=3D"nofollow noopener noreferrer" sh=
ape=3D"rect" ymailto=3D"mailto:hyambu@gmail.com" target=3D"_blank" href=3D"=
mailto:hyambu@gmail.com">hyambu@gmail.com</a>&gt; wrote:<br clear=3D"none">=
<div class=3D"yiv4584774629yqt6447495952" id=3D"yiv4584774629yqt40645"><blo=
ckquote class=3D"yiv4584774629gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex;"><div dir=3D"ltr">Hello<br clear=3D=
"none"><div><br clear=3D"none"></div><div>Is it possible to have as input t=
o a function , a whole table contents,&nbsp; if the table is a small lookup=
 table?</div><div><br clear=3D"none"></div><div>Something like this&nbsp; &=
nbsp;</div><div>&nbsp;&nbsp;<br clear=3D"none"></div><div>CREATE or replace=
 function test (IN (select * from table1) )&nbsp; </div></div></blockquote>=
</div><div><br clear=3D"none"></div><div>No.&nbsp; Function arguments are d=
ata types, not contents.&nbsp; Queries go inside the function body.</div><d=
iv><br clear=3D"none"></div><div>David J.</div><div>&nbsp;</div><div>&nbsp;=
</div>
</div></div></div>
            </div>
        </div></body></html>
------=_Part_301089_873857642.1623765699597--