That's about 30 hours from here. I might have to pass, for now. But if it's on Youtube I'd be interested.
I think I understand recursive CTEs well enough now from the description in the documentation and studying the code. I'm impressed at the brevity of your solution, although in practice it does not perform well. The far more complex implementation from Pasma performs better, I think largely because it applies rules to narrow the search space. My challenge now is to implement that feature in Andl. Regards David M Bennett FACS Andl - A New Database Language - andl.org -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, 11 June 2015 2:01 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] User-defined types -- in Andl On 6/9/15, david at andl.org <david at andl.org> wrote: > I don't remember the last time I saw SQL like this. Understanding it > might be the challenge... I'll be giving a talk on CTEs this Saturday at the Southeastern Linuxfest (http://www.southeastlinuxfest.org/) during which I will explain and demonstrate how to write a simple CTE that solves a sudoku puzzle. If you cannot attend in person, I'm told that the talk will be streamed live to youtube. -- D. Richard Hipp drh at sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users