3 ms·
Solving problems with Postgres is wildly different than solving them with mssql informix or Oracle. So I would say "there is no SQL".
by nurettin 9y ago
Solving problems with Postgres is wildly different than solving them with mssql informix or Oracle. So I would say "there is no SQL".
- hluska 9y agoI don't agree with that. Once you understand the basics of building performant databases/queries, that knowledge will persist across databases. There are small differences in syntax and features, but any remotely competent person should be able to pick those up while they go, provided they understand what happens under the hood when they execute SQL.
- irrational 9y agoIn what way are they wildly different? I spent 15 years working in Oracle and the last 2 years working in Postgres. They are slightly different (Postgres adheres to the standard much more closely than Oracle), but 95% of my knowledge of SQL transferred from one to the other.
- nurettin 9y agoA simple example would be "how to select groupwise maximum" where Postgres would respond well to a correlated subquery and Oracle would respond well to a window function and derived table. The engines and optimizations are different.