PostgreSQL and the SQL standards process

Posted Sep 21, 2011 19:45 UTC (Wed) by Cyberax (✭ supporter ✭, #52523)
In reply to: PostgreSQL and the SQL standards process by dskoll
Parent article: PostgreSQL and the SQL standards process

Have you ever tried recursive queries in SQL with CTEs?

...shudder...

FLWOR is as clear as day compared to that.

Though I'm not against even better language, FLWOR should be considered just as a nice guide about how query languages should be written. In any case, it's a bit XML-specific and should be extended for relational data with features like explicit joins instead of nested loops.

PostgreSQL and the SQL standards process

Posted Sep 21, 2011 19:55 UTC (Wed) by dskoll (subscriber, #1630) [Link]

Have you ever tried recursive queries in SQL with CTEs?

Ugh, no. :) I guess my use of SQL is not at that level. I agree that such queries are unreadable piles of evil, and predicting how they will perform is like reading a crystal ball.