3 ms·
This is a really long article for saying "precedence between || and + is different between PostgreSQL and Oracle SQL".
by aerzen 8mo ago
This is a really long article for saying "precedence between || and + is different between PostgreSQL and Oracle SQL".
- mahtodeepak 8mo agoI 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.
- aerzen 8mo agoSorry 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/ https://aljaz.murerzen.eu/sql-precedence/