I am the author of the Blog. I wanted to share the journey as part of analysis. Blog is not on precedence between || and + but primarily highlight fact that implicit casting cause it to change in Oracle.
Ideally precedence is same in both engines.
Sorry for being dismissive. I've written a post [1] that highlights the core discrepancy between the two dialects. I like criticizing SQL and having a documented case like this is nice.
I draft most of my blog first without any AI and later refine it for flow and clarity. These time i had used it to influence the flow and agree it changed a lot. But i liked the flow so kept it like that.
This is a really long article for saying "precedence between || and + is different between PostgreSQL and Oracle SQL".
I am the author of the Blog. I wanted to share the journey as part of analysis. Blog is not on precedence between || and + but primarily highlight fact that implicit casting cause it to change in Oracle. Ideally precedence is same in both engines.
Sorry for being dismissive. I've written a post [1] that highlights the core discrepancy between the two dialects. I like criticizing SQL and having a documented case like this is nice.
[1]: https://aljaz.murerzen.eu/sql-precedence/
Obviously written by AI.
I draft most of my blog first without any AI and later refine it for flow and clarity. These time i had used it to influence the flow and agree it changed a lot. But i liked the flow so kept it like that.
Yeah. There's nothing wrong with using AI to draft an article, but ffs have some taste and edit it significantly once the draft is written.
Feedback taken. I have been blogging since long and have my own way for telling technical stuff.