[sqlite] Sqlite incompatibility with Postgres

> Actually, MIN still is fundamentally a first-order itself. The dyadic > function call "x min y" returns either x or y depending on how they compare. > The list form is then repeated application of the binary min(). This is > directly comparable to your example of list plus/sum which is repetiti

[sqlite] Sqlite incompatibility with Postgres

On Fri, 20 May 2016 14:17:25 +1000 "dandl" wrote: > Every aggregation function is at least second order: a function that > applies a function to the set. So for MIN the function is 'less > than', for SUM() the function is 'plus' and so on. In Andl > aggregation functions are provided by fold(), w

[sqlite] Optimising max(datetime()) queries.

Hi List, I've come across a little curiousity and was wondering what was going on (and if there's an even better way). I have some DATETIME data: 2013-06-03 16:08:55+01:00 2013-06-03 16:46:22+00:00 2013-06-03 16:48:57+00:00 ... I want to get the the start of the day that was 28 days ago from th

[sqlite] SQL logic error or missing database no such table

Hi, We've a .Net Windows Service that uses SQLite 1.0.93.0 for database operations. The SQLite package contains two binaries, system.data.sqlite.dll and sqlite.interop.dll. The database is encrypted and the blob it contains is encrypted as well. SQLite is intermittently throwing following exceptio

[sqlite] Searching this mailing lsit

On 21 May 2016, at 10:07am, Cecil Westerhof wrote: > 2016-05-21 3:19 GMT+02:00 Kasajian, Kenneth < > Kenneth.Kasajian at schneider-electric.com>: > >> *** Confidentiality Notice: This e-mail, including any associated or >> attached files, is intended solely for the individual or entity to which

[sqlite] Searching this mailing lsit

2016-05-21 3:19 GMT+02:00 Kasajian, Kenneth < Kenneth.Kasajian at schneider-electric.com>: > *** Confidentiality Notice: This e-mail, including any associated or > attached files, is intended solely for the individual or entity to which it > is addressed. This e-mail is confidential and may well a

[sqlite] Searching this mailing lsit

On 21 May 2016 at 10:07, Cecil Westerhof wrote: > 2016-05-21 3:19 GMT+02:00 Kasajian, Kenneth < > Kenneth.Kasajian at schneider-electric.com>: > >> *** Confidentiality Notice: This e-mail, including any associated or ... > ?I would make sure that the above does not get send to mailing-lists. It

[sqlite] Multiple line command pasted to shell is split in history

On 20 May 2016, at 17:35, Jaromir Obr wrote: > Expected result: > > SELECT REPLACE(ingredients,'enriched_','') as item_ingredients > FROM baked_goods; > > Actual result: > > FROM baked_goods; > > Note: It works well in MariaDB shell, in the same terminal Either way has its advantages.

[sqlite] Searching this mailing lsit

> 2016-05-21 3:19 GMT+02:00 Kasajian, Kenneth schneider-electric.com>: > > > *** Confidentiality Notice: This e-mail, including any associated or > > attached files, is intended solely for the individual or entity to which > > it is addressed. This e-mail is confidential and may well also be lega