If what appears is what was entered, then you need to change the closing ’ to a
closing ' (that is, from a funny word-processor symbol that looks like a quote
but is really an apostrophe used in typesetting but is not a quote that
terminates a string, into a quote to terminate the string) ...
sqlite> select
load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
sqlite> select
load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib');
You have to be careful because most modern e-mail clients, unless specifically
configured otherwise, are designed specifically for sending web-pages
containing glossy-brochures by SMTP and are not suitable for use in exchanging
plain-text that must not be tampered with. In this case the culprit was likely
a configuration option that substituted "pretty quotes" and "apostrophes" for
functional quotes. You can tell because the pretty-quotes are, well, pretty
and curvy, such as are around your original “median”, while actual quotes
that-do-something (other than look pretty) do not have curves: "median". The
same mis-feature also changes single-quotes ' into apostrophes ’ in the
circumstances it thinks such changes are appropriate depending on its
substitution rules.
> -----Original Message-----
> From: sqlite-users [mailto:[email protected]]
> On Behalf Of Ronald Gombach
> Sent: Wednesday, 23 November, 2016 04:57
> To: SQLite mailing list
> Subject: Re: [sqlite] SQLite binary with Math Functions for OS-X?
>
> David,
>
> The brew/install worked and created the sqlite app and library in the
> locations specified in your instructions.
>
> I can load the math lib from the .load (dot load) command line,
> The median function works as I wanted
>
> but the ‘load_extension’ select statement did not work; I get a command
> entry continuation line as follows
>
> sqlite> select
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
> …>
>
> I need to be able to load the extension from within a PHP script
>
> Thoughts?
>
> Thanks.
>
> Ron Gombach
> mailto:[email protected] <mailto:[email protected]>
>
>
> > On Nov 21, 2016, at 12:15 PM, David Goldwich
> <[email protected]> wrote:
> >
> > On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach <[email protected]>
> wrote:
> >>
> >> Is there a pre-c binary of SQLIte available for down load that includes
> a math library. I particularly need the “median” function.
> >>
> >> If not, can someone point me to instructions on compilation command
> line to include the math library (OS-X).
> >
> > Homebrew can do that conveniently:
> >
> > $ brew update && brew install --with-functions sqlite
> > $ /usr/local/opt/sqlite/bin/sqlite3
> > sqlite> select
> load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’);
> > sqlite> select pi();
> > pi()
> > 3.14159265358979
> >
> > The “math library” here being extension-functions.c from
> > https://www.sqlite.org/contrib/.
> > _______________________________________________
> > sqlite-users mailing list
> > [email protected]
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
