Ok, thank you for that hint. But it is still very unconvenient. How can I
define a view based on your suggestion? I want to have something like
CREATE VIEW foo AS SELECT {if has stddev then stddev(...) else null} FROM ...
- Original Message -
From: Keith Medcalf
To: SQLite mailing list
You can check if what you need is available on a connection and either load it
if needed or just abort:
sqlite> select * from pragma_function_list order by 1, 2;
name builtin
- --
aavg 0
abs1
acos
select name from pragma_function_list where name == 'M_Pi' collate nocase;
returns the name of the function if it exists. See pragma function_list
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
> exact numeric representations.
+1 for that as had already been in consideration for version 4
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I agree in that not every math function can be included by default. My problem,
however, is that I cannot know whether a user uses my self-compiled version
with built-in extension-functions.c, or a downloaded version from sqlite.org.
It would be very, very helpful (especially regarding views!) t
Before starting to support SQL2016 features, I would suggest support for
missing features of older SQL standard versions first ;)
- Original Message -
From: sky5w...@gmail.com
To: SQLite mailing list
Sent: Wednesday, May 22, 2019, 21:29:40
Subject: [sqlite] SQL Features That SQLite Doe
On Wednesday, 22 May, 2019 16:56, James K. Lowden
wrote:
>On Wed, 22 May 2019 14:20:11 -0600
>"Keith Medcalf" wrote:
>> (such as was added to DB2 back in the late 80's early 90's, and
>> which I do not think anyone else has implemented as nicely anywhere
>> else)
>That's an interesting aside
On Wednesday, 22 May, 2019 19:06, Simon Slavin wrote:
>Since there are people posting who appear know about these things …
>Suppose I want SQlite to handle my own type. Or to do its best to
>simulate that. IP address, x/y location, something like that. What
>should I be doing ? Do I store B
If realloc() fails (see // Here.), the memory occupied by zLine will not be
de-allocated.
(http://www.c-faq.com/malloc/realloc.html)
static char *local_getline(char *zPrompt, FILE *in){
char *zLine;
int nLine;
int n;
nLine = 100;
zLine = malloc( nLine );
if( zLine==0 ) return 0;
n
Hi Richard,
I just realized I didn't include the mailing list in my previous response
to you, so I'm doing that now with the contents of the SQL file I sent you
previously. I've also included a copy of my original email in plaintext as
the HTML formatted SQL queries got mangled when it was process
Since there are people posting who appear know about these things …
Suppose I want SQlite to handle my own type. Or to do its best to simulate
that. IP address, x/y location, something like that. What should I be doing ?
Do I store BLOBs and define my own COLLATEs ? Or didn't I read somewhe
> On May 22, 2019, at 3:55 PM, James K. Lowden wrote:
>
> I've always thought user-defined types were unnecessary except as a
> convenience.
User-defined types are quite important if you’re doing fancy stuff in
user-defined functions, where data that’s stored in tables as blobs has an
inte
Umm...
geometries I use with Postgis & Spatialite - I don't have a database without
them.
Can anyone come up with a data domain for which location has no relevance?
I used to think I had some (like taxonomies & dictionaries), but I've been
corrected in each case :-)
also IP addresses
Brent Wood
On Wed, 22 May 2019 14:20:11 -0600
"Keith Medcalf" wrote:
> (such as was added to DB2 back in the late 80's early 90's, and
> which I do not think anyone else has implemented as nicely anywhere
> else)
That's an interesting aside. It would make an interesting OT thread,
if you're inclined to s
Thanks for the test case. This problem should now be fixed on trunk.
Please try it out and let us know if you encounter any additional
probglems.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http
On Wednesday, 22 May, 2019 11:51, sky5w...@gmail.com wrote:
>Please add a note to the omitted page that many basic math functions
>are NOT supported. (sqrt,mod,power,stdev,etc.)
Traditionally "math library" functions provided by the various language
runtimes were not included becase this would
On 5/22/19, Sebastian Kemper wrote:
>
> Hello Richard,
>
> I have run-tested this with qemu on two targets until now:
>
> arm_arm1176jzf-s_vfp
> armeb_xscale
>
> Both worked fine. Unfortunately I still don't have feedback from the
> user. He didn't receive my mail. I've sent it again and will get
Yes, I expected some pushback. However, my post was to save the next person
having to search for answers. I did not expect to requote the top line of
the page I listed?
"SQLite implements most of the common features of SQL. Rather than try to
list all the features of SQL that SQLite does support, *
On Mon, May 20, 2019 at 09:10:20PM +0200, Sebastian Kemper wrote:
> On Mon, May 20, 2019 at 02:46:47PM -0400, Richard Hipp wrote:
> > On 5/20/19, Sebastian Kemper wrote:
> > > In OpenWrt's forum a user raised a topic about being unable to use
> > > Asterisk on his armeb xscale device.
> >
> > Plea
On Wed, 2019-05-22 at 14:24 -0400, Reid Thompson wrote:
> On Wed, 2019-05-22 at 19:05 +0100, Simon Slavin wrote:
> > [EXTERNAL SOURCE]
> >
> >
> >
> > On 22 May 2019, at 6:51pm, sky5w...@gmail.com wrote:
> >
> > > Please add a note to the omitted page that many basic math functions are
> > > N
How we can anyone document functions that do not exist?, they are
infinite and many of them (most) are not currently known to humanity.
Also, if somewhere it said "SQLite cannot do sqr() it would lie - sure
vanilla sqlite might not, but there are many ways in which it does.
!. Add-ons - there
On Wed, 2019-05-22 at 19:05 +0100, Simon Slavin wrote:
> [EXTERNAL SOURCE]
>
>
>
> On 22 May 2019, at 6:51pm, sky5w...@gmail.com wrote:
>
> > Please add a note to the omitted page that many basic math functions are
> > NOT supported. (sqrt,mod,power,stdev,etc.)
>
> Which ones should the docum
Regarding: ... many basic math functions are NOT supported.
(sqrt,mod,power,stdev,etc.)...I am curious why these are not available ...now
reading how to build my own extensions...
I'm not addressing the documentation question, but extended math functions
have been available since 2010.
On the *c
On 22 May 2019, at 6:51pm, sky5w...@gmail.com wrote:
> Please add a note to the omitted page that many basic math functions are NOT
> supported. (sqrt,mod,power,stdev,etc.)
Which ones should the documentation mention ? Can you find us a specification
of SQL which includes that these functions
I'm often scrambling to decide whether to do complicated queries in SQL or
my own code?
...Getting oh so close to a working query, only to fail at function not
defined?!!
Please add a note to the omitted page that many basic math functions are
NOT supported. (sqrt,mod,power,stdev,etc.)
https://www
25 matches
Mail list logo