Re: [sqlite] Index list

2017-02-11 Thread Dominique Devienne
On Sat, Feb 11, 2017 at 3:54 PM Simon Slavin wrote: > On 11 Feb 2017, at 2:50pm, Rob van der sloot > wrote: > > I want to use the index of a specific column of a table as a pulldown > list > > But I can't find any syntax how to select or view an index. > > Sorry. There is no way to find the con

Re: [sqlite] Index list

2017-02-11 Thread Niall O'Reilly
On 11 Feb 2017, at 14:50, Rob van der sloot wrote: > I want to use the index of a specific column of a table as a pulldown list > in my application. Wouldn't SELECT DISTINCT column FROM table; give you the same effect? I expect the query planner would use the table or not according to

Re: [sqlite] Index list

2017-02-11 Thread Simon Slavin
On 11 Feb 2017, at 2:50pm, Rob van der sloot wrote: > I want to use the index of a specific column of a table as a pulldown list > in my application. > But I can't find any syntax how to select or view an index. Sorry. There is no way to find the contents of an index. However, you can do SELE