User: Password:
|
|
Subscribe / Log in / New account

PostgreSQL and the SQL standards process

PostgreSQL and the SQL standards process

Posted 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.


Copyright © 2017, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds