On 2016/02/18 10:38 PM, Stephan Beal wrote:
> On Thu, Feb 18, 2016 at 9:16 PM, Stephan Beal <sgbeal at googlemail.com> 
> wrote:
>
>> Okay, i've hit a small stump and i'm looking for a hint without giving it
>> away:
>>
>> January and February 2016:
>>
>> [stephan at host:~/tmp]$ sqlite3 < cal.sql
>>                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
>>
>
> [stephan at host:~/tmp]$ sqlite3 < cal.sql
> ---------------------\n              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
> ---------------------\n  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
>
> doh! How do i get newlines?

Use the Mandelbrot set CTE for a cheat-sheet...
CHAR(13)||CHAR(10)... etc.


Reply via email to