Re: [sqlite] PRAGMA index_info explanation

2012-01-11 Thread Marco Bambini
Thanks a lot Tom, don't know why this email was delivered even today, it was sent yesterday and Dr. Hipp already replied me. Anyway… thanks a lot for your detailed explanation, I really appreciate. -- Marco Bambini http://www.sqlabs.com On Jan 11, 2012, at 4:06 PM, BareFeetWare wrote: >

Re: [sqlite] PRAGMA index_info explanation

2012-01-11 Thread BareFeetWare
Hi Marco, In reply to: > From the PRAGMA index_info documentation: > This pragma returns one row each column in the named index. The first column > of the result is the rank of the column within the index. The second column > of the result is the rank of the column within the table. The third

[sqlite] PRAGMA index_info explanation

2012-01-11 Thread Marco Bambini
>From the PRAGMA index_info documentation: This pragma returns one row each column in the named index. The first column of the result is the rank of the column within the index. The second column of the result is the rank of the column within the table. The third column of output is the name of

Re: [sqlite] PRAGMA index_info explanation

2012-01-10 Thread Richard Hipp
On Tue, Jan 10, 2012 at 12:30 PM, Marco Bambini wrote: > From the PRAGMA index_info documentation: > This pragma returns one row each column in the named index. The first > column of the result is the rank of the column within the index. The second > column of the result is the

[sqlite] PRAGMA index_info explanation

2012-01-10 Thread Marco Bambini
>From the PRAGMA index_info documentation: This pragma returns one row each column in the named index. The first column of the result is the rank of the column within the index. The second column of the result is the rank of the column within the table. The third column of output is the name of