Could someone take a look at <http://www.sqlite.org/lang_with.html>
please ? This page was inaccessible via a web filter used in one of my students' homes because of its use of the pseudo-word 'cnt'. My guess is that this is because some online fora users use it as a form of a certain rude word used more commonly in British/Australian/etc. English than it is in American English. Since this pseudo-word is just an arbitrary name, would it be possible to substitute its 9 mentions with whatever term it's an abbreviation of ? I'm not certain but I think it means 'count'. If COUNT is a reserved word in anything important (it's not in SQLite but perhaps the writer wants to avoid it anyway) some other word could be used. Whoever wrote that page is obviously used to three letter abbreviations since 'org' is used further down for an 'organisation' table. That one doesn't seem to be a problem, or at least the filter report didn't mention it. By the way, I think it easier to understand WITH when the explanation includes one or two examples of the Ordinary Common Table Expressions before it gets into recursion. This allows the writer to explain the syntax and uses of WITH first, letting the student get used to those because they have to absorb the additional complications of RECURSIVE. But that's just my opinion. Of course, SQLite has sub-SELECTs as well, which may overlap with the use of WITH. Simon.
