Re: [sqlite] man page bug

On Thu, 30 Oct 2014 17:37:54 +0100 (CET) Carsten Kunze wrote: > the man page sqlite3.1 contains the .cc request which is not > compatible with the man macro package (and hence must not be used in > a man page). The below patch rectifies that problem and clears up some

Re: [sqlite] sqlite_column_table_name() and table alias name

> On 31 Oct 2014, at 12:30pm, Jose F. Gimenez wrote: > > SELECT a, b, table2.c, alias.c > FROM table1 > LEFT JOIN table2 ON ... > LEFT JOIN table2 AS alias ON ... > > the API sqlite_column_table_name() applied to both columns 3 and 4 returns > . I know that belongs to

Re: [sqlite] Index without backing table

On Fri, Oct 31, 2014 at 8:35 AM, Alessandro Marzocchi < alessandro.marzoc...@gmail.com> wrote: > I think what he wants is a way to create an index on a virtual table. > SQLite cannot build an index on a virtual table because SQLite has no idea if and when the content of the table will change and

Re: [sqlite] Index without backing table

On Fri, Oct 31, 2014 at 1:35 PM, Alessandro Marzocchi < alessandro.marzoc...@gmail.com> wrote: > I think what he wants is a way to create an index on a virtual table. > +1 to that. --DD ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Index without backing table

31 October 2014, 14:19:56, by "Richard Hipp" : > I don't really understand what you are asking, but I suspect that > http://www.sqlite.org/withoutrowid.html is probably the answer you are > looking for. I have just realized, how stupid my question is. Actually I don't even

Re: [sqlite] Index without backing table

I think what he wants is a way to create an index on a virtual table. I faced a similar problem recently and seeing that there was no apparent way to do that I steered to a completely different way. Lets say I have a immutable binary file which contains n rows of struct containing 10 (let's name

[sqlite] sqlite_column_table_name() and table alias name

Hi, in this kind of statements: SELECT a, b, table2.c, alias.c FROM table1 LEFT JOIN table2 ON ... LEFT JOIN table2 AS alias ON ... the API sqlite_column_table_name() applied to both columns 3 and 4 returns . I know that belongs to in both cases, but is there any way to get for column 3

Re: [sqlite] Index without backing table

I don't really understand what you are asking, but I suspect that http://www.sqlite.org/withoutrowid.html is probably the answer you are looking for. On Fri, Oct 31, 2014 at 8:15 AM, Hick Gunter wrote: > Can you give an example of what such a beast would look like? > > CREATE

Re: [sqlite] Index without backing table

Can you give an example of what such a beast would look like? CREATE TABLE not_exist (A, B, C, D, E);-- for illustrative purposes CREATE INDEX no_table ON not_exist (A,B,C,D,E); -- has to be covering index The only efficient order to return and/or select rows is by {A}, {A,B}, {A,B,C}, ...

[sqlite] man page bug

Hello, the man page sqlite3.1 contains the .cc request which is not compatible with the man macro package (and hence must not be used in a man page). There are many easy ways to solve this, I suggest to simply replace the .cc with .tr %. and then all '.' at beginning of a line with a '%'.

[sqlite] SQLITE_NOMEM error on Linux 64 bits

Hi all, I am facing a problem while trying to use Sqlite3 on linux 64 bits with LabVIEW. I already posted this here (http://stackoverflow.com/questions/26635506/sqlite-nomem-error-on-linux-64- bits

[sqlite] Index without backing table

Is there a way to have index without table? Is it possible to achieve this with virtual talbe tricks but without implementing B-tree myself? I need this both for space effciency and to minimize disk I/O (by avoiding table updates). ___ sqlite-users

Re: [sqlite] Installation_Procedure

On 31 Oct 2014 at 03:38, Ayub Mytheen wrote: > I tried to configure SQLLite Setting in my laptop.i extract two zip file > from your link. i tried to set path environment variable > .We cant to configure to sqllite.if any body can help to guide how to > configure