On Wed, 22 May 2019 17:56:23 -0700
Jens Alfke wrote:
> > 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
e the values should be just
NULL.
- Original Message -
From: Simon Slavin
To: SQLite mailing list
Sent: Thursday, May 23, 2019, 12:34:39
Subject: [sqlite] SQL Features That SQLite Does Not Implement
On 23 May 2019, at 7:57am, Thomas Kurz wrote:
> CREATE VIEW foo AS SELECT {if ha
On 23 May 2019, at 7:57am, Thomas Kurz wrote:
> CREATE VIEW foo AS SELECT {if has stddev then stddev(...) else null} FROM ...
'if' in SQL language is CASE.
Near the beginning of your code, try to execute a function that contains
stddev(). Make a note of whether it compiles without errors or n
On Thu, May 23, 2019 at 11:09 AM Keith Medcalf wrote:
> >Keith, as can be seen below, those pragma_*list eponymous vtables are
> >you referring to as not built-in.
>
> Actually they are. They are the eponymous vtables for the corresponding
> pragma's:
>
> pragma function_list;
> pragma collation
On Thursday, 23 May, 2019 02:08, Dominique Devienne wrote:
>On Thu, May 23, 2019 at 7:39 AM Keith Medcalf
>wrote:
>> 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
ssage-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Thomas Kurz
>Sent: Thursday, 23 May, 2019 00:58
>To: SQLite mailing list
>Subject: Re: [sqlite] SQL Features That SQLite Does Not Implement
>
>Ok, thank you for that hint. B
On Thu, May 23, 2019 at 7:39 AM Keith Medcalf wrote:
> 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
> -
list
Sent: Thursday, May 23, 2019, 07:18:45
Subject: [sqlite] SQL Features That SQLite Does Not Implement
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
Kurz
>Sent: Wednesday, 22 May, 2019 22:19
>To: SQLite mailing list
>Subject: Re: [sqlite] SQL Features That SQLite Does Not Implement
>
>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
&g
--Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Thomas Kurz
>Sent: Wednesday, 22 May, 2019 22:19
>To: SQLite mailing list
>Subject: Re: [sqlite] SQL Features That SQLite Does Not Implement
>
>I agree in that not
> 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
!) to have some kind
of a "check function" so that one could write
SELECT CASE WHEN defined('stddev') THEN stddev(foo) ELSE NULL END FROM bar
- Original Message -
From: Keith Medcalf
To: SQLite mailing list
Sent: Wednesday, May 22, 2019, 22:20:11
Subject: [sqlit
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
> 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
IP addresses
Brent Wood
From: James K. Lowden
To: sqlite-users@mailinglists.sqlite.org
Sent: Thursday, May 23, 2019 10:56 AM
Subject: Re: [sqlite] SQL Features That SQLite Does Not Implement
On Wed, 22 May 2019 14:20:11 -0600
"Keith Medcalf" wrote:
> (such as was added to
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
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
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 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
24 matches
Mail list logo