Re: [sqlite] SQLite binary with Math Functions for OS-X?

2016-11-23 Thread Ronald Gombach
>> 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 t

Re: [sqlite] SQLite binary with Math Functions for OS-X?

2016-11-23 Thread Keith Medcalf
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

Re: [sqlite] SQLite binary with Math Functions for OS-X?

2016-11-23 Thread Ronald Gombach
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

Re: [sqlite] SQLite binary with Math Functions for OS-X?

2016-11-21 Thread David Goldwich
On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach 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 >

Re: [sqlite] SQLite binary with Math Functions for OS-X?

2016-11-21 Thread Roman Fleysher
Can't you count how many rows there are and then sort by the variable of interest, limiting output to half the count, all within SQL? Roman Sent from my T-Mobile 4G LTE Device Original message From: Ronald Gombach Date: 11/21/16 7:12 AM (GMT-05:00) To: