Re: [sqlite] returning multiple rows from custom functions

On Thu, Dec 15, 2005 at 09:17:48PM +, Andrew McDermott wrote: > For example, I'm currently computing a histogram in application code for > a moderately sized table (7+ million rows), but I'm wondering whether it > would be quicker to get the results computed via a custom SQLite > function.

[sqlite] returning multiple rows from custom functions

Hi, Is it possible to get an aggregate function to return more than one row? For example, I'm currently computing a histogram in application code for a moderately sized table (7+ million rows), but I'm wondering whether it would be quicker to get the results computed via a custom SQLite

Re: [sqlite] RSS code patch

On Dec 15, 2005, at 12:21 PM, [EMAIL PROTECTED] wrote: http://www.cvstrac.org/cvstrac/tktnew Thanks!

Re: [sqlite] RSS code patch

Will Leshner <[EMAIL PROTECTED]> wrote: > If a person wanted to propose a patch to the code that generates the > RSS from the timeline messages, where would be a good place to start? > http://www.cvstrac.org/cvstrac/tktnew -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] RSS code patch

If a person wanted to propose a patch to the code that generates the RSS from the timeline messages, where would be a good place to start? In other words, where does that code live? Is that something that we mortals can look at in order to suggest changes? The reason I ask is because I

Re: [sqlite] Problem with floating point fields, and a feature request

We have previously discussed the issue of fixed point. It is my contention that Sqlite would be much enhanced by having a fixed point numeric type using ASCII decimal digits in display format. It would be very much in keeping with the general philosophy of avoiding strict typing and would

Re: [sqlite] Usability problem with quoted names

D. Richard Hipp wrote: > The rule in SQLite is > that a column name (or table name) can be any sequence of > characters that does not include US-ASCII punctuation or > control characters and does not begin with a digit. It is cool! I have not seen this in SQLite documentation > Note also that

Re: [sqlite] Using time and date values

"Henning Folger" <[EMAIL PROTECTED]> wrote: > > I am looking for a simple way of using date and time values with > sqlite3. http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Using time and date values

Brad wrote: I am looking for a simple way of using date and time values with sqlite3. I have some Ctime classes (VC++.net) which have to be stored in the database and they should be compared. If the class you're using has .Value property, or a way to easily transform the date from one

Re: [sqlite] Usability problem with quoted names

Teg wrote: > Why not use "?" then fill it in the the actual value later? Quoting > and having to actually look at values to make sure they were legal > gave me no end of problems now I: > ... > I never pass any kind of quoted values any more. I'm sorry, my previous post is quite obscure. This

Re: [sqlite] Problem with floating point fields, and a feature request

A simple "fuzzy" tolerance will not solve the problem, only mask it for the most common cases. A single floating point addition of two numbers can result in ZERO bits of precision.