For example I have a composite primary key on columns
id, age in the following table:
can I somehow query the table using composite primary key in where clause, somehow like that:
SELECT * FROM table WHERE primary_key < (3, 22)
with result like that:
I cannot query it like
where id < 4 and age < 22 because it would compare every column separately.
You can compare tuples with other operators than just
where (id, age) < (3, 22)
is valid SQL.
But I have to admit that I find that condition highly confusing given the column names chosen