*_res
?The question came up of how many posts are not getting tagged with the *_res
family of tags, and these queries will return those answers.
select count(*) from posts
where (width <= 250 and height <= 250)
and not tags @> Array['thumbnail']
select count(*) from posts
where (width <= 500 and height <= 500)
and not tags @> Array['low_res']
-- the wiki seems to imply [[thumbnail]] is a subset of [[low_res]]
select count(*) from posts
where (width >= 1600 or height >= 1200)
and not tags @> Array['hi_res']
-- [[hi_res]] is a superset of [[absurd_res]]
select count(*) from posts
where (width >= 3200 or height >= 2400)
and not tags @> Array['absurd_res']
select count(*) from posts
where (width >= 10000 or height >= 10000)
and not tags @> Array['superabsurd_res']