Re: [sqlite] How can we use POWER(2,32) like function in SQLite

On 20 January 2011 05:23, Sunil Bhardwaj wrote: > Hi > > Please suggest, How can we use POWER(2,32) like function in SQLite? Vanilla SQL has no power function, but see extension-functions.c in http://sqlite.org/contrib. > > Thanks > Sunil Bhardwaj > Ext. 1125 (0120-2567001) > 9818868910 Regards

[sqlite] Documentation typos - part no.3

Hi! Again, some more Documentation typos with some fun while we're at it: 1. http://www.sqlite.org/c3ref/intro.html "These pages _defined_ the C-language interface to SQLite." Good old days! 2. http://www.sqlite.org/quickstart.html "... sqlite3_exec() on line _27_ ..." Most C++ editors i

Re: [sqlite] How can we use POWER(2,32) like function in SQLite

On Thu, Jan 20, 2011 at 8:23 AM, Sunil Bhardwaj < sbhard...@ipolicynetworks.com> wrote: > Hi > > Please suggest, How can we use POWER(2,32) like function in SQLite? > > This particular call or any with base 2 can be replaced with bitwise shift SELECT 1 << 32 Max

Re: [sqlite] Patch: FTS3 Snawball Stemmer support

Good day, Alexey. I thank you for your post as it sent me on a bit of a learning endeavor. I have found that there is a framework to support user-developed stemmers already, with one built-in stemmer (Porter) coded into the DBMS by default. SQLite v3.7.4 facilitates the use FTS3 or FTS4. The Po

Re: [sqlite] Documentation typos - part no.3

On Thu, Jan 20, 2011 at 4:16 AM, Marian Cascaval wrote: > Hi! > > Again, some more Documentation typos > with some fun while we're at it: > Thanks for sending these in. I have implemented fixes which have been uploaded to the "draft" website at http://www.sqlite.org/draft/index.html or which can

[sqlite] Patch to allow DISTINCT in multi-argument aggregate functions

Good news, everyone! I've taught SQLite to feel love! No, wait, that's not it. I spotted the thread 'how to use group_concat uniquely' today, and felt inspired, so I wrote a quick patch. The patch allows a multi-argument aggregate function to be passed DISTINCT, under the restriction that every o

Re: [sqlite] Patch to allow DISTINCT in multi-argument aggregate functions

Stephen Oberholtzer wrote: > Good news, everyone! I've taught SQLite to feel love! FINALLY. I put in that feature request like 3 years ago. -- Eric A. Smith Computer programs don't like being anthropomorphized. ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Patch to allow DISTINCT in multi-argument aggregate functions

On 20 Jan 2011, at 7:48pm, Eric Smith wrote: > Stephen Oberholtzer wrote: > >> Good news, everyone! I've taught SQLite to feel love! > > FINALLY. I put in that feature request like 3 years ago. Unfortunately it has to be wrapped in a transaction, and if you don't begin one yourself SQLite ma

[sqlite] How can we put check constraints on a column

Hi How can we put check constraints on a column in sqlite, while creating a table. We want to restrict values for a column in a range say '1 to 10'. Thanks Sunil Bhardwaj Ext. 1125 (0120-2567001) 9818868910 ___ sqlite-users mailing list sqlite-users@sq

Re: [sqlite] How can we put check constraints on a column

On Jan 20, 2011, at 20:51, Sunil Bhardwaj wrote: > How can we put check constraints on a column in sqlite, while creating a > table. > > We want to restrict values for a column in a range say '1 to 10'. The standard SQL way works. Are you experiencing otherwise? I did a google sear

[sqlite] sqlite3_trace active on FTS3 (sub-)statements, pathologically bad at stringifying (segment) BLOBs (quasi-enhancement request)

In our Mozilla debug builds we use sqlite3_trace to expose the SQL statements that are invoked via our PR_LOG logging subsystem. This usually works out well but the trace also catches FTS3's statements in its net. During a segment merge, a segment in a Thunderbird FTS3 table can easily be >10