Re: How to pass table column values to function

2023-02-11 Thread jian he
On Sat, Feb 11, 2023 at 3:55 PM Andrus wrote: > Hi! > > Table source contains integer column. Its values should be passed to > function for selecting data from other table. > > I tried > > CREATE OR REPLACE FUNCTION > public.TestAddAssetTransactions(dokumnrs int[]) > RETURNS int

Re: How to pass table column values to function

2023-02-11 Thread Marcos Pegoraro
Em sáb., 11 de fev. de 2023 às 07:10, Andrus escreveu: > Hi! > > Table source contains integer column. Its values should be passed to > function for selecting data from other table. > > I tried > > CREATE OR REPLACE FUNCTION > public.TestAddAssetTransactions(dokumnrs int[]) > RET

How to pass table column values to function

2023-02-11 Thread Andrus
Hi! Table source contains integer column. Its values should be passed to function for selecting data from other table. I tried     CREATE OR REPLACE FUNCTION public.TestAddAssetTransactions(dokumnrs int[]) RETURNS int AS     $BODY$     with i1 as (     INSERT INTO