AdventOfCode 2022 Day 25

WITH recursive input AS (
  SELECT row_number() over() as rn, line, length(line) as len
  FROM lance_input
), origin AS (
  SELECT rn as _row, x.idx as _col, x.word as pos
  FROM (
    SELECT row_number() over() as rn, line
    FROM lance_input
  ) t, regexp_split_to_table(line, '') with ordinality as x(word, idx)
), power_result AS (
  SELECT x._row, (CASE WHEN pos = '-' THEN -1 WHEN pos = '=' THEN -2 ELSE pos :: INTEGER END) * power(5, idx) as result
  FROM (
    SELECT x._row, y.len - x._col as idx, pos
    FROM origin x
    JOIN input y
    ON x._row = y._row
  ) t
)
select sum(result) From power_result;