Re: [sqlite] built-in printf() not supporting \n or \t ?

2019-11-28 Thread Keith Medcalf
On Thursday, 28 November, 2019 09:21, Richard Damon wrote: >\n and \t are not 'printf' features, but C string features, that \ is an >escape introducer for compiling a string, and if followed by a letter >like n or t it builds a string with the special value represented by >that function. The

Re: [sqlite] built-in printf() not supporting \n or \t ?

2019-11-28 Thread Richard Damon
On 11/28/19 10:24 AM, Dominique Devienne wrote: > Obviously it's ugly to use concatenation and char() to format a string > literal with tabs and newlines. > Is there a better way? Why doesn't printf() support newlines and tabs like > it's C cousin? --DD > > PS: Built-in printf() also doesn't

[sqlite] built-in printf() not supporting \n or \t ?

2019-11-28 Thread Dominique Devienne
Obviously it's ugly to use concatenation and char() to format a string literal with tabs and newlines. Is there a better way? Why doesn't printf() support newlines and tabs like it's C cousin? --DD PS: Built-in printf() also doesn't support positional params, to "emulate" newline with printf(