Postgres 16

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

select version();

version

PostgreSQL 16.6 (Debian 16.6-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

create table my_table (id bigint);

CREATE TABLE

insert into my_table values (1), (2), (3), (5)

INSERT 0 4

create type my_type as
    (
        id bigint,
        value character varying(100)
    );

CREATE TYPE

create or replace function my_function (
        my_array my_type[])
        returns table (id bigint)
        language 'plpgsql'
    as $BODY$
    begin
    return query
        select t.id from my_table as t
        where t.id in (
            select ar.id
            from unnest(my_array) as ar
        );
    end;
    $BODY$;

CREATE FUNCTION

select * from my_function(array[(1, 't')::my_type, (3, 'b')::my_type]);

id

1

3

SELECT 2