Re: [sqlite] Quoting strings for SQLite

Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/17/2010 07:12 PM, Dan Bishop wrote: > >> Newlines, backslashes, and double quotes can be included literally. The >> only other character you need to worry about is NUL. >> > > Funnily enough I'm busy writing my

Re: [sqlite] STandard Deviation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/18/2010 06:37 PM, Peter Haworth wrote: > Does Sqlite have a STDEV function? Don;t see it listed under the core > or aggregate functions. You can find that and many other functions in a contributed extension. See the bottom of http://sqlite.o

Re: [sqlite] Restriction of updating unique column

> > Contrary to what occurs in other engines, SQLite seems to > > assert constraints at insert/delete time, ignoring the fact that > > (insert or delete) trigger will increment or decrement the upper part > > of the tree interval on HI and LO keys (in the case of a nested tree). > >This /should/ b

Re: [sqlite] Restriction of updating unique column

On 19 Apr 2010, at 2:03am, Jean-Christophe Deschamps wrote: > Contrary to what occurs in other engines, SQLite seems to > assert constraints at insert/delete time, ignoring the fact that > (insert or delete) trigger will increment or decrement the upper part > of the tree interval on HI and LO

Re: [sqlite] STandard Deviation

Not in sqlite itself but stddev_samp and stddev_pop are available in the spatialite loadable extension. Be careful since they interchanged sample and population in one version of the extension. On Sun, Apr 18, 2010 at 9:37 PM, Peter Haworth wrote: > Does Sqlite have a STDEV function?  Don;t see i

[sqlite] STandard Deviation

Does Sqlite have a STDEV function? Don;t see it listed under the core or aggregate functions. Thanks, Pete Haworth ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Restriction of updating unique column

>I found the the restriction of updating unique column in ver3.6.21. >and same problem is reported in follwoing mail > >Marc-Andre Gosselin wrote: >date: Thu, 16 Jun 2005 >title: "[sqlite] Update unique column" > > > > I discovered a behavior in SQLite 2.8.16 that doesn't conform to > the SQL > >

[sqlite] Restriction of updating unique column

Hi members, I found the the restriction of updating unique column in ver3.6.21. and same problem is reported in follwoing mail Marc-Andre Gosselin wrote: date: Thu, 16 Jun 2005 title: "[sqlite] Update unique column" > > I discovered a behavior in SQLite 2.8.16 that doesn't conform to the SQL > st

Re: [sqlite] Data optimization with GLOB, virtual deletes

On 18 Apr 2010, at 7:08pm, Mike Goins wrote: >> Also, I don't recall your saying whether a single composite index was faster >> than separate indexes? Is it? >> >> Regards >> Tim Romano > > Interesting suggestion. Separate indexes look to be slightly faster > than the composite.Separate i

Re: [sqlite] Please help test the latest query planner changes

Op 16-apr-2010, om 19:51 heeft D. Richard Hipp het volgende geschreven: > > On Apr 16, 2010, at 11:52 AM, Max Vlasov wrote: >> >> SELECT StihiAuthors.Id As AuthId, StihiAuthCandidates.Date as Date, >> StihiAuthCandidates.Num as Num FROM StihiAuthors >> INNER JOIN StihiAuthCandidates ON >> StihiA

Re: [sqlite] Data optimization with GLOB, virtual deletes

> Just guessing, but column 'path' probably has greater cardinality than > column 'extension'. What happens if you reverse the order of these columns > in the index? > i.e. (basename, path, extension, deleted) (deleted, basename, extension, path) This order actually provides the most to least sig

Re: [sqlite] Quoting strings for SQLite

So I'm summarising for the net. To render a string into quotable form (1) Replace each apostrophe in it with two apostrophes. (2) Surround it with single apostrophes. That's all there is to worry about apart from 0x00 characters, which don't worry me for other reasons. Do those two things and

Re: [sqlite] how to submit a file with sql to sqlite"

very cool! Thanks, Gabor. On Sun, Apr 18, 2010 at 12:16 PM, Gabor Grothendieck wrote: > On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu wrote: >> dear listers, >> i am wondering if there is a way to submit a file with many sql >> statements, say several hundred lines,  to sqlite. >> >> thanks for y

Re: [sqlite] how to submit a file with sql to sqlite"

> -Ursprungligt meddelande- > Från: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] För Gabor Grothendieck > Skickat: den 18 april 2010 18:17 > Till: General Discussion of SQLite Database > Ämne: Re: [sqlite] how to submit a file with sql to sqlite" > > On Sun,

Re: [sqlite] how to submit a file with sql to sqlite"

On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu wrote: > dear listers, > i am wondering if there is a way to submit a file with many sql > statements, say several hundred lines,  to sqlite. > > thanks for your insight. C:\tmp2>type a.sql create table tab (a,b); insert into tab values(1, 2); insert i

[sqlite] how to submit a file with sql to sqlite"

dear listers, i am wondering if there is a way to submit a file with many sql statements, say several hundred lines, to sqlite. thanks for your insight. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf