> bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin
> There must be a Windows element in there, though. On the Mac I can create
a
> create a project in Xcode which has C, C++, Objective-C, Java and Python
code
> in (probably other languages too) and they can all call functions in
On 05/11/2016 05:24 PM, Jan Berkel wrote:
> I?m currently implementing a custom FTS5 tokenizer which I?d like to
> automatically register for each db connection.
>
> So I tried to register an extension hook with sqlite3_auto_extension but when
> my code is called the FTS_* modules have not been
Hi List,
Let's say I have a table with a simplified structure like this:
/create table my_table(//
//time_date DATE,//
//num INTEGER//
//);/
My data has three rows and looks like this:
/2016-01-01; 3//
//2016-01-01; 1//
//2016-01-03; 2/
I want
On 11 May 2016, at 11:20pm, Jonathan wrote:
> //time_date DATE,//
SQLite has no DATE type. Put your data in that table and try this command:
SELECT time_date,typeof(time_date) FROM my_table
Then try it again, this time defining that column as TEXT.
Simon.
On 2016/05/12 12:20 AM, Jonathan wrote:
> Hi List,
> Let's say I have a table with a simplified structure like this:
> /create table my_table(//
> //time_date DATE,//
> //num INTEGER//
> //);/
>
> My data has three rows and looks like this:
> /2016-01-01; 3//
I should add...
The initial CTE setting up minDT and maxDT can be ANY dates, it doesn't
have to come from the MIN/MAX in my_table, for example:
WITH dtRange(minDT,maxDT) AS (
SELECT '2015-12-30 00:00:00', datetime(date('now','localtime','-3
months'))
-- 30 December 2015 to today 3
It's a minor point, but can someone confirm that:
Postgres accepts (but Sqlite does not)
LIMIT ALL
LIMIT ALL OFFSET nnn
OFFSET nnn
Sqlite accepts (but Postgres does not):
LIMIT -1 OFFSET nnn
LIMIT -1
These all have the same meaning of no limit, but there is no common ground
in the syntax.
Hi,
Can you provide me link of PCRE support for SQLite. I need to install it on
Linux RHEL ES Release 4 with i686.
-Bhagwat
On Mon, May 9, 2016 at 6:18 PM, Chris Brody wrote:
> On Mon, May 9, 2016 at 2:20 PM, Richard Hipp wrote:
> > On 5/9/16, Chris Brody wrote:
> >> On Wed, May 4, 2016
On May 12, 2016, at 7:36 AM, Bhagwat Balshetwar wrote:
>
> Can you provide me link of PCRE support for SQLite. I need to install it on
> Linux RHEL ES Release 4 with i686.
First Google result for ?sqlite pcre?:
https://github.com/ralight/sqlite3-pcre
Hi Simon,
I know that the "DATE" type isn't actually a type in SQLite and that there
are no date-specific constraints, but I find it a convenient indicator (to me
and potentially anyone else who's going to see the code) as to the type of data
that is to be held in that column. I figured
> It's a minor point, but can someone confirm that:
>
> Postgres accepts (but Sqlite does not)
> LIMIT ALL
> LIMIT ALL OFFSET nnn
> OFFSET nnn
>
> Sqlite accepts (but Postgres does not):
> LIMIT -1 OFFSET nnn
> LIMIT -1
>
> These all have the same meaning of no limit, but there is no common
>
On 12 May 2016, at 11:24am, dandl wrote:
> Sqlite accepts (but Postgres does not):
> LIMIT -1 OFFSET nnn
> LIMIT -1
>
> These all have the same meaning of no limit, but there is no common ground
> in the syntax.
Yes and Yes. Documented behaviour. There are some strange situations if the
On 12 May 2016, at 3:55pm, Jonathan Moules
wrote:
> I know that the "DATE" type isn't actually a type in SQLite and that there
> are no date-specific constraints, but I find it a convenient indicator (to me
> and potentially anyone else who's going to see the code) as to the type of
>
> I?m currently implementing a custom FTS5 tokenizer which I?d like to
> automatically register for each db connection.
>
> So I tried to register an extension hook with sqlite3_auto_extension but when
> my code is called the FTS_* modules have not been initialized, because
>
On Thu, May 12, 2016 at 6:07 PM, dandl wrote:
> > > Sqlite accepts (but Postgres does not):
> > > LIMIT -1 OFFSET nnn
> > > LIMIT -1
> > >
> > > These all have the same meaning of no limit, but there is no common
> > > ground in the syntax.
> >
> > Yes and Yes. Documented behaviour. There are
15 matches
Mail list logo