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
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
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
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
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
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
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
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
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
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
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
11 matches
Mail list logo