Home > mailing lists

function INPUT as whole table - Mailing list pgsql-sql

From	Yambu
Subject	function INPUT as whole table
Date	June 15, 2021 13:59:21
Msg-id	CALhHtcAGqGgCDKYg5rgwxqjXDhJnAH+qYxFDAya2Jn4CWxSV1A@mail.gmail.com Whole thread Raw
Responses	Re: function INPUT as whole table Re: function INPUT as whole table
List	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) )

From: Steve Midgley
Date: 03 June 2021, 16:55:40
Subject: Re: Update to whole table

From: "David G. Johnston"
Date: 15 June 2021, 15:41:07
Subject: Re: function INPUT as whole table