News for hackers. Stuff that matters.
Re:Advent of Code 2024 in pure SQL by marcle on Sunday December 29, 2024 @04:02AM (#42538684)
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?

Re:Advent of Code 2024 in pure SQL by marcle on Sunday December 29, 2024 @11:44AM (#42541016)
Answering my own question: Umbra and PostgreSQL include "#" as an operator for bitwise xor, whereas DuckDB does not.