Re: [sqlite] printf function is shown in docs but not found when I try it

n Sat, 19 Apr 2014 10:38:01 +0100, c...@isbd.net wrote: >Simon Slavin wrote: >> >> On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: >> >> > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. >> > >> > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're

Re: [sqlite] printf function is shown in docs but not found when I try it

Simon Slavin wrote: > > On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: > > > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. > > > > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're likely to move > > to anything newer during its lifetime. > > If

Re: [sqlite] printf function is shown in docs but not found when I try it

On 18 Apr 2014, at 2:49pm, c...@isbd.net wrote: > Xubuntu 13.10 (which I'm currently using) has sqlite 3.7.17. > > Xubuntu 14.04 has sqlite 3.8.2, I'm not sure if they're likely to move > to anything newer during its lifetime. If you're writing C or C++ code then you don't need to use

Re: [sqlite] printf function is shown in docs but not found when I try it

On 4/18/2014 8:49 AM, c...@isbd.net wrote: Alternatively are there any other reasonably practical ways to format numeric output? Specifically I want to format floating point numbers into a fixed format like NNN.N. Your application can provide custom functions callable from queries. Tcl

Re: [sqlite] printf function is shown in docs but not found when I try it

Richard Hipp wrote: > On Thu, Apr 17, 2014 at 8:03 AM, wrote: > > > In the documentation at http://www.sqlite.org/lang_corefunc.html > > there's a printf function, however when I try and use it in sqlite3 > > (on xubuntu 13.10) it says "Error: no such function:

Re: [sqlite] printf function is shown in docs but not found when I try it

On Thu, Apr 17, 2014 at 8:03 AM, wrote: > In the documentation at http://www.sqlite.org/lang_corefunc.html > there's a printf function, however when I try and use it in sqlite3 > (on xubuntu 13.10) it says "Error: no such function: printf". > > Is this because I need to load some

[sqlite] printf function is shown in docs but not found when I try it

In the documentation at http://www.sqlite.org/lang_corefunc.html there's a printf function, however when I try and use it in sqlite3 (on xubuntu 13.10) it says "Error: no such function: printf". Is this because I need to load some extra library to make it work or is it just not available in the