RE: [sqlite] Mathematical "power" operator?

2006-12-19 Thread Jesús López
to do it with Tcl, I just know how to do it with c#. Regards: Jesús López -Mensaje original- De: Jeff Godfrey [mailto:[EMAIL PROTECTED] Enviado el: martes, 19 de diciembre de 2006 21:45 Para: sqlite-users@sqlite.org Asunto: [sqlite] Mathematical "power" operator? Hi All, New

RE: [sqlite] Query Optimizer and INTEGER PRIMARY KEY

2006-12-19 Thread Jesús López
Richard, Thanks for your reply. I have tried CREATE INDEX IX_Post ON Post(CategoryID) and I have got the same results. I did it before posting my first post :-), I guessed integer primary key field is in every index, but not sure. Regards: Jesús López -Mensaje original- De: [EMAIL

RE: [sqlite] Query Optimizer and INTEGER PRIMARY KEY

2006-12-19 Thread Jesús López
Dennis, Thanks for your reply. Sorry for the typo, I wrote it directly on Outlook and I did not check it. I will fill a bug report (a ticket) Regards: Jesús López -Mensaje original- De: Dennis Cote [mailto:[EMAIL PROTECTED] Enviado el: martes, 19 de diciembre de 2006 16:30 Para

[sqlite] Query Optimizer and INTEGER PRIMARY KEY

2006-12-18 Thread Jesús López
PRIMARY KEY field was not in IX_Posts index? _ Regards Jesús López