I'm nose deep in an Oracle to Postgres conversion at the moment and from that ex... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		singingfish on Jan 12, 2023 \| parent \| context \| favorite \| on: The Yaml document from hell I'm nose deep in an Oracle to Postgres conversion at the moment and from that experience, among others, I can absolutely assure you that although booleans are definitely simple they are also most definitely a very sharp edge case.

falcolas on Jan 12, 2023 | [–]

But who doesn't love the OracleDB tri-state boolean?

/s

int_19h on Jan 12, 2023 | [–]

Booleans, or NULL specifically?

singingfish on Jan 13, 2023 | [–]

yes (in oracle - at least the early 21st century version I'm using you have to roll your own boolean-ish - traditionally char(1).

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact