3 ms·
It's useful for people new to Postgres, since many of these things are particular to Postgres.
by irrational 7y ago
It's useful for people new to Postgres, since many of these things are particular to Postgres.
- tempguy9999 7y agoNot really. Most is pretty well standard SQL (CTE optimisation fence pre PG12 being one exception, and there are a couple more, but really it's mostly standard stuff).
- barrkel 7y agoThe :: syntax for CAST() is also a psql-ism.
- tejtm 7y agoMaybe that is what it is now, but I still have muscle memory using it in Informix.
- irrational 7y agoMaybe. I come from the Oracle world and the majority of these don't apply to Oracle.