How to use the IN clause for multiple columns

Question

I am using Postgres and I would like to put together the following sql queries

select * from t1 where type=57 and idt=2001 and date=1;
select * from t1 where type=59 and idt=2001 and date=1;
select * from t1 where type=57 and idt=2002 and date=3;
select * from t1 where type=57 and idt=2001 and date=2;
select * from t1 where type=59 and idt=2002 and date=1;

together in only one statement, like this:

select * from t1 where (type, idt, date) in 
{
(57, 2001, 1),
(59, 2001, 1),
(57, 2002, 3),
(57, 2001, 2),
(59, 2002, 1),
}

but I get the syntax error.

What's the correct syntax to achieve it?

Answer 1

Where did you find, that curly braces would be correct in this case? Just use regular parentheses:

select * 
from t1 
where (type, idt, date) in (
                             (57, 2001, 1),
                             (59, 2001, 1),
                             (57, 2002, 3),
                             (57, 2001, 2),
                             (59, 2002, 1)
                           )