Advent of Code 2022 Day 4 in SQL (run with `\I program_04.sql` from psql console)

formatter.rb

#! /usr/bin/env ruby

# Just reformats the input into Postgres inclusive range syntax in CSV:
# 2-4,6-8   =>   "[2,4]","[6,8]"
File.readlines('input_04.txt').each do |line|
  r1, r2 = line.split(',')
  a, b = r1.split('-')
  x, y = r2.chomp.split('-')
  puts "\"[#{a},#{b}]\",\"[#{x},#{y}]\""
end

program_04.sql

drop table if exists camp_cleanups;
create table camp_cleanups (
  id serial primary key,
  r1 int4range not null,
  r2 int4range not null
);

\copy camp_cleanups (r1, r2) from program './formatter.rb' with csv;

-- part 1
select
  sum(
    case when (r1 <@ r2 or r1 @> r2) then 1
    else    0
    end
  )
from camp_cleanups;

-- part 2
select
  sum(
    case when r1 && r2 then 1
    else 0
    end
  )
from camp_cleanups;