4 ms·
Syntax-wise, Postgres is not much different from MySQL. You just have to learn how to use window functions which takes a bit.
by minimaxir 11y ago
Syntax-wise, Postgres is not much different from MySQL. You just have to learn how to use window functions which takes a bit.
- mdaniel 11y agoI don't think people have a concern that Postgres is the one with the wacky syntax. And it's been my experience that unless the team is very disciplined, if a language offers a thing, you'll find it in the codebase. Thus, ripping out all the backticks where you've used "select" or "from" as a column name isn't a postgres problem. To really go out on a limb, I would posit that MySQL's view on RDBMS functionality influences its use, which I bet does not square with more traditional systems. Anytime one finds a shift in world view, the code becomes hard to rewrite and still behave the same way.