----- Original Message ----- From: "Frank Millman" <fr...@chagford.com>
To: <sqlite-users@sqlite.org>
Sent: Monday, August 25, 2014 2:32 PM
Subject: Re: [sqlite] Problem with recursive CTE



Could it be a version problem? I am using the version bundled with Python3.4.1 for Windows.

sqlite3.sqlite_version shows '3.8.3.1'

I have just tried it on a Fedora 18 machine, which has version 3.7.13. There it gives 'near "WITH": syntax error'

It seems that the WITH statement is a fairly recent addition. I will upgrade and try again.


I have upgraded to version 3.8.6, and I can confirm that it now works. Thanks very much, Richard and Keith

Now I have to figure out how to get Python to use the upgraded version, but that is one for the python mailing list.

Frank

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to