Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t_table (id int4, json_data jsonb);

INSERT INTO t_table 
(id, json_data) 
VALUES
( 1 ,'{"key": "key1", "value": "3222"}'),
( 2,'{"key": "key1", "value": "224"}'),
( 3,'{"key": "key1", "value": "1243"}');

3 rows affected

CREATE OR REPLACE FUNCTION  query1(incoming_ids jsonb)
 RETURNS table  (id int4,json_data jsonb)
 LANGUAGE sql
 IMMUTABLE
AS $function$
select * from t_table where id in (
SELECT x::int from jsonb_array_elements(incoming_ids)  x)
$function$
select * from query1('[1,3]');


id
json_data


1
{"key": "key1", "value": "3222"}

3
{"key": "key1", "value": "1243"}

id	json_data
1	{"key": "key1", "value": "3222"}
3	{"key": "key1", "value": "1243"}