On Wed, 10 Apr 2019 11:05:59 +0100, you wrote:
>Wednesday, April 10, 2019, 10:28:55 AM, Luuk wrote:
>
>> On 10-4-2019 10:28, Kees Nuyt wrote:
>
>>> sqlite> select * from pragma_function_list;
>
>> sqlite> select * from pragma_function_list;
>> Error: no such table: pragma_function_list
>
> From t
On 10/04/2019 18:28, Kees Nuyt wrote:
On Wed, 10 Apr 2019 13:17:23 +1000, John wrote:
I have not used extensions before. I understand that some are included
in the amalgamation source file and that some of these are enabled by
default. So, which ones are built-in and which of those are enable
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
On Tuesday, 9 April, 2019 21:17, John McMahon wrote:
>I have not used extensions before. I understand that some are
>included in the amalgamation source file and that some
Interesting. Must be that the pragmas that take arguments need parens when
used in table valued function form. I've never tried without them when
using a pragma that way.
Anyways, the sqlite3 shell is built with that introspection option, at
least on Linux (tested with one built from source myself
Wednesday, April 10, 2019, 11:16:07 AM, Shawn Wagner
wrote:
> It should be pragma_function_list(). Note the parentheses.
That doesn't make a difference if the shell hasn't been built with
-DSQLITE_INTROSPECTION_PRAGMAS, and they don't appear necessary for a
pragma that IS built-in (such as "pra
It should be pragma_function_list(). Note the parentheses.
On Wed, Apr 10, 2019, 2:29 AM Luuk wrote:
>
> On 10-4-2019 10:28, Kees Nuyt wrote:
> > On Wed, 10 Apr 2019 13:17:23 +1000, John wrote:
> >
> >> I have not used extensions before. I understand that some are included
> >> in the amalgamati
Wednesday, April 10, 2019, 10:28:55 AM, Luuk wrote:
> On 10-4-2019 10:28, Kees Nuyt wrote:
>> sqlite> select * from pragma_function_list;
> sqlite> select * from pragma_function_list;
> Error: no such table: pragma_function_list
From the help page (https://www.sqlite.org/pragma.html#pragma_fun
On 10-4-2019 10:28, Kees Nuyt wrote:
On Wed, 10 Apr 2019 13:17:23 +1000, John wrote:
I have not used extensions before. I understand that some are included
in the amalgamation source file and that some of these are enabled by
default. So, which ones are built-in and which of those are enabled
On Wed, 10 Apr 2019 13:17:23 +1000, John wrote:
> I have not used extensions before. I understand that some are included
> in the amalgamation source file and that some of these are enabled by
> default. So, which ones are built-in and which of those are enabled in
> the standard downloadable W
On 10-4-2019 05:17, John McMahon wrote:
which ones are built-in and which of those are enabled in the standard
downloadable Win32 SQLite CLI
Some possibility tho show this like (i.e.) '.extensions' would be very
nice!?
___
sqlite-users mail
Hi,
I have not used extensions before. I understand that some are included
in the amalgamation source file and that some of these are enabled by
default. So, which ones are built-in and which of those are enabled in
the standard downloadable Win32 SQLite CLI?
If an extension is built-in and
11 matches
Mail list logo