5 ms·

I never cease to be amazed at how well Postgres maintains decades-old ACID SQL standards while churning out these innovative advances to the spec.

• Amezarak 8y ago
  Postgres is great, but I don't think there is a serious rdms that doesn't have recursive ctes.
  • twic 8y ago
    Does Oracle have them now? There was a time when it had some janky CONNECT BY syntax of its own.
    • Zardoz84 8y ago
      Oracle >= 10 have it. CTEs are inside of SQL standard.
  • marzell 8y ago
    I'm kinda trying to figure out why this is on HN today. Usually articles, even reposts, contain some sort of novel content or ideas. Recursive CTEs in SQL databases are well known and have been for years.