Settings

Theme

Advent of Code 2024 in pure SQL

databasearchitects.blogspot.com

8 points by congoe a year ago · 2 comments

Reader

marcle a 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 a year ago

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

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection