Re: function INPUT as whole table - Mailing list pgsql-sql

From Tom Lane
Subject Re: function INPUT as whole table
Date
Msg-id 354524.1623764008@sss.pgh.pa.us
Whole thread Raw
In response to function INPUT as whole table  (Yambu <hyambu@gmail.com>)
List pgsql-sql
Yambu <hyambu@gmail.com> writes:
> Is it possible to have as input to a function , a whole table contents,  if
> the table is a small lookup table?

Not directly, but you might be able to achieve the effect by opening a
cursor and passing the cursor name to the function, which could fetch
from it.  See the examples in the cursor section of the plpgsql manual.

            regards, tom lane



pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: function INPUT as whole table
Next
From: Viswanatha Sastry
Date:
Subject: Re: function INPUT as whole table