On Thu, Feb 18, 2016 at 10:22 PM, Stephan Beal <sgbeal at googlemail.com> wrote:
> On Thu, Feb 18, 2016 at 10:19 PM, Richard Hipp <drh at sqlite.org> wrote: > >> On 2/18/16, Stephan Beal <sgbeal at googlemail.com> wrote: >> > >> > Thanks again to all for the feedback and suggestions! >> > >> >> After your talk, can we publish your calendar CTE as another example >> in the SQLite documentation? >> > > i would be humbled. No need to wait for the presentation (still no time > slot scheduled - might be 4-6 weeks). i'll shoot it off to you once i've > added some comments about what each part is for. > Here we go: http://fossil.wanderinghorse.net/download/cal.sql i'm not claiming this is a world-class solution, but considering how lowly my CTE skills are, i'm quite pleased with myself :). [stephan at host:~/tmp]$ sqlite3 < cal.sql ---------------------- Jan 2016 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ---------------------- Feb 2016 Mo Tu We Th Fr Sa Su 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 <snip> -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
