Same SQL, Different Results: A Subtle Oracle vs. PostgreSQL Migration Bug
databaserookies.wordpress.comThis 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.
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.