function INPUT as whole table

From: Yambu <hyambu(at)gmail(dot)com>
To: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: function INPUT as whole table
Date: 2021-06-15 10:59:21
Message-ID: CALhHtcAGqGgCDKYg5rgwxqjXDhJnAH+qYxFDAya2Jn4CWxSV1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2021-06-15 12:41:07 Re: function INPUT as whole table
Previous Message Steve Midgley 2021-06-03 13:55:40 Re: Update to whole table