Using tuple() in WHERE clause

When you need to filter data with a complex, repetitive condition using AND, OR, and parentheses like this:

SELECT 
    county, 
    town, 
    avg(price) as avg_price,
    median(price) as median_price 
FROM uk.uk_price_paid
WHERE 
    ((county = 'GWYNEDD') AND (town = 'ABERDOVEY'))
    OR 
    ((county = 'LANCASHIRE') AND (town = 'ACCRINGTON'))
GROUP BY ALL

consider using tuples with the IN clause like this:

SELECT 
    county, 
    town, 
    avg(price) as avg_price,
    median(price) as median_price 
FROM uk.uk_price_paid
WHERE 
    (county, town) IN (('GWYNEDD', 'ABERDOVEY'), ('LANCASHIRE', 'ACCRINGTON'))
GROUP BY ALL

Don't worry about performance issues. The indexes are still used :)
See this changelog entry.

These examples are based on The UK property prices dataset.