top | item 42532695

Advent of Code 2024 in pure SQL

8 points| congoe | 1 year ago |databasearchitects.blogspot.com

2 comments

order

marcle|1 year ago

This is very interesting code that uses Umbra v0.2-957, PostgreSQL 17.2, and DuckDB v1.1.3.

One minor point: some of the problems could not be implemented in DuckDB due to a missing xor operator - but the documentation includes an xor function (https://duckdb.org/docs/sql/functions/numeric.html#xorx-y) for the same version. Is the form of the function not suitable?

marcle|1 year ago

Answering my own question: Umbra and PostgreSQL include "#" as an operator for bitwise xor, whereas DuckDB does not.