By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
create table test
( id varchar(20),
text varchar(20)
);
insert into test values(1, 'a')
,(2, 'b')
,(3, 'c');
CREATE TABLE
INSERT 0 3
--I understand, to check multi-column in where condition, I can do this
SELECT * FROM test
WHERE (id, text) = ANY (VALUES('1', 'a'), ('2', 'b'), ('3', 'c'))
| id | text |
|---|---|
| 1 | a |
| 2 | b |
| 3 | c |
SELECT 3
create or replace function test_function
( tests in test[]
)returns setof test as
$f$ SELECT id, text
FROM test
NATURAL JOIN unnest(tests);
$f$ language SQL;
CREATE FUNCTION
select*from test_function(array[ (1,'a')::test
,(2,'b')::test
,(3,'c')::test])
| id | text |
|---|---|
| 1 | a |
| 2 | b |
| 3 | c |
SELECT 3
select*from test_function('{"(1,a)","(2,b)","(3,c)"}'::test[])
| id | text |
|---|---|
| 1 | a |
| 2 | b |
| 3 | c |
SELECT 3