How to generate tuple matching query based on multiple column?

[md-redwan-hossain]

Is there any way to generate queries as given below?? I did't find anything that can achieve as the followings.

SELECT * 
FROM "ProductStocks" ps
where (ps."DepotId", ps."ProductId", ps."ProductBatchId") IN ((1, 1, 1),(1, 1, 2));

SELECT *
FROM person
WHERE (firstname, lastname) = ( ('Arthur', 'Dent') );

SELECT *
FROM person
WHERE (firstname, lastname) > ('Arthur', 'Dent');

SELECT *
FROM person
WHERE (firstname, lastname) IN ( ('Arthur', 'Dent'), ('Ford','Prefect') )