Became part of the SQL standard in 1999. Available in SQLite3 since 2014-02-03 (3.8.3).
https://www.sqlite.org/lang_with.html --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of Ian Zimmerman >Sent: Tuesday, 27 March, 2018 21:22 >To: [email protected] >Subject: Re: [sqlite] json question > >On 2018-03-27 19:26, Keith Medcalf wrote: > >> Actually, it is very simple and straightforward to implement >> hierarchical structures using Relational Database Models. > >But not recursive structures (or to be more precise, recursive >queries) >which are the next very natural step. > >You can have a "parent" database and you can use it to answer queries >like "all X, Y where X is a parent of Y", "all X, Y where X is a >grandparent of Y", "all X, Y where X is a great-grandparent of Y" >etc. >All that with a single table. But no amount of SQL mastery will >allow >you to answer "all X, Y where X is an ancestor of Y". > >-- >Please don't Cc: me privately on mailing lists and Usenet, >if you also post the followup to the list or newsgroup. >To reply privately _only_ on Usenet and on broken lists >which rewrite From, fetch the TXT record for no-use.mooo.com. >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
