Hacker News new | ask | show | jobs
by tempguy9999 2406 days ago
Not 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).
2 comments
barrkel 2406 days ago
The :: syntax for CAST() is also a psql-ism.
link
tejtm 2406 days ago
Maybe that is what it is now, but I still have muscle memory using it in Informix.
link
irrational 2406 days ago
Maybe. I come from the Oracle world and the majority of these don't apply to Oracle.
link