| |||||||||||||
PostgreSQL and the SQL standards processPostgreSQL and the SQL standards processPosted Sep 21, 2011 19:31 UTC (Wed) by dskoll (subscriber, #1630)In reply to: PostgreSQL and the SQL standards process by Cyberax Parent article: PostgreSQL and the SQL standards process
FLWOR looks like the "best" [sic] of both SQL and XML... a nastier horror I could not imagine. :)
(Log in to post comments)
PostgreSQL and the SQL standards process Posted Sep 21, 2011 19:45 UTC (Wed) by Cyberax (✭ supporter ✭, #52523) [Link]
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.
|
|||||||||||||